Forum Discussion
conditional formatting not working in every cell
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.
For context, each column (C thru F) represents a week for a month. So column C will be completed on first week, D on second week, etc. My original post included column B, but for now I am leaving that one out as I am just currently focusing on these four. Each screen shot here contains C, D, E, and F.
As you can tell I changed the formula from my original post. Weird thing is everything was yellow in column F originally. I cleared out the conditional formatting, but entered it again to provide the screen shot. Now cell F28 stays white, along with B28. In addition, the range in each selection does not turn white when a value is enter (second screen shot). Bottom row in second screen shot is row 42.
Unfortunately I can only guess what you exactly want to do. My assumption is that you have to adapt the rules for conditional formatting to the applies to ranges as shown in the screenshot.
Applies to range: =$F$25:$F$40 rule: =F25=0
Applies to range: =$E$25:$E$40 rule: =E25=0
and so on.
The cell the rule refers to has to be the top left cell of the applies to range.
- Do you mean, for example, instead of the condition of =c42=0 for range =$C$25:$C$40 - the condition should be =d42=0?
If I am not understanding, that is fine. It seems I found the solution. I changed the condition to, using column C as an example, to =$c$42=0
And it resolved the issue. Something is still very buggy about this. Either way - I'm crossing my fingers that this works as I continue to test it out.
Thank you so much for your replies. Greatly appreciate you taking the time.