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 White. Each day, new data is added to a Row - one Row for each day of the year.
So far there is one cell which is ignoring the CF, displaying a value of £0.00...!
I have attached images showing the 'offending' cell & the corresponding CF - I even added a CF rule for the specific cell, but it is still being ignored!
Any suggestions or help would be appreciated. If you need to see the CF rules for the whole Worksheet, or the formulae applied to any/all cells in the Worksheet, let me know. TIA
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)
2 Replies
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.
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)
