Forum Discussion
Conditional formatting is inprecise
Hi everyone! I'm having trouble with conditional formatting in Excel. I basically achieved what I wanted but the result isn't exactly what I wanted and could lead to mistakes for me and my team. I am...
You probably selected the wrong cell when creating the rule, for the conditional formatting formulas refer to different rows.
Select column L, delete the existing rules and replace them with a single rule with the following formula:
=OR(AND(L1>=REF!$B$1,L1<=REF!$B$2,REF!$B$4>=REF!$B$1,REF!$B$4<=REF!$B$2),AND(L1>REF!$B$2,L1<=REF!$B$3,REF!$B$4>REF!$B$2,REF!$B$4<=REF!$B$3))
I modified the formulas on the REF sheet slightly - your formula would return the 30th of December as the last day of the year in a leap year.
See the attached version.
Thanks a lot! That did it! I'm learning as I go but needed that last little push!
Thanks again!
Thanks again!