Forum Discussion
Solved
conditional formatting not working in every cell
So I have conditional formatting where a range will be filled in yellow if the value equals zero. No idea why, but cells b29:b40 and f29:f40 are not getting formatted. Is there some other formatting ...
This is the rule for conditional formatting of the cells with value zero:
=A1=0This is the range to which formatting is applied:
=$A$1:$F$30Maybe this is helpful for your task.
Just noticed if I do >= (equal to greater than) it all turns yellow.. I manually entered zeroes in there. So no way it is some small decimal number that is hiding itself. Bad thing is - it would be a pain to rebuild this workbook.