Conditional formatting issue in Reports
Summary:
I have a basic grid with a couple of formula rows and then a second reference grid which I pull the results of the main grid formulas into, using the CellValue() function.
Values are coming through as expected.
The issue I have is with the Conditional Formatting. I want to apply formatting in the Reference grid, if the value is 0 display OK (Green), if the value is greater than 1000 display Not OK (Red).
As you can see the first formula/condition is working and I get Ok (green). But the second one is not working. It should be showing Not Ok (Red), but it remains white.
0