Aug 18 2022 01:35 PM
Aug 18 2022 01:35 PM
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.
Aug 18 2022 01:48 PM
Aug 18 2022 01:49 PMSolution
This is the rule for conditional formatting of the cells with value zero:
This is the range to which formatting is applied:
Maybe this is helpful for your task.
Aug 19 2022 06:29 AM
Aug 19 2022 06:36 AM
Aug 19 2022 09:05 AM
Can you attach a screenshot which shows the rule(s) for conditional formatting you currently work with along with the applies to ranges and the results in the worksheet (with row and column descriptions like the screenshot in my earlier reply)?
Aug 19 2022 09:36 AM
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.
Aug 19 2022 10:06 AM
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.
Aug 19 2022 10:12 AM