Forum Discussion
Solved
Conditional Formatting (CF) being 'ignored'... by ONE cell in a Worksheet!
I have a Worksheet where Conditional Formatting (CF) is set so that any cells with a (currency) value that is 'equal to or less than £0.00 (GBP)' are hidden - by setting the Font & Fill colours to Wh...
If you increase the number of decimal places in the number format, you will probably see that the value looks similar to 0.00000000123.
I assume that the cells contain formulas. To correct the problem, round the formula results to 2 decimal places. Change
=expression
to
=ROUND(expression, 2)
Based upon your reply, I found a simpler solution. I changed the CF Rule to 'Less than 0.01' (the lowest denomination in GBP) which has worked.