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.
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.
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.
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)?
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.