Forum Discussion
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 that is in place that can be impacting this? I looked carefully at these cells and I am not noticing what could be causing this. The weird thing is when I start messing with the formula, it starts filling in some of the cells. For example, I changed the formula to sum(f35:f40)=0 and cells f36:f40 became yellow.
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.
8 Replies
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.
- You're a genius. Still annoying that the formatting is not taking place, but what I ended up doing was for each column, if the total is zero, then that range of cells will be yellow. Before it was just the range of cells needing to be zero.
Super frustrating that this was even an issue. Thank you so much. Your reply helped me figure out another workable solution.- Welp, I was wrong. Now when I enter a value some of the cells still stay yellow, and this other "solution" did not work for column B. I guess something is wrong with this workbook. I cannot see any other cause other than an inherent problem with the workbook itself.
- 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.
