Forum Discussion
Conditional Formatting for values not equal to 0 is not working properly
I am trying to highlight the Discrepancies in my data where the values not being equal to 0 should be highlighted red. But the problem is that some rows that have the value 0, are also being highligh...
Found a workaround and hope this is helpful:
Pick a color for zero, then set the same colour for a range that accomodates rounding errors: MIN (-0.01) and MAX (0.01)
Then pick the colour you want for reconciling items and start from the boundaries set for zero so it looks like this: