Hi,
I have a workflow where im looking at putting conditional formatting on the "Grand Total" and "% of Limit" rows, to highlight cell background as RED
a) any values in the two rows < 0
b) if the limit in Grand Total is exceeded, eg. x > 100M.
Note that i have used a union tool to join the rows 1 & 2 and 3 & 4 together.
| | Limit 100M | | | | | |
| | Description | Date T-1 | Date T | Date T+1 | Date T+2 | Date T+3 |
| 1 | abc | | | | | |
| 2 | def | | | | | |
| 3 | Grand total | x | y | etc | | |
| 4 | % of Limit | A | B | etc | | |
