P45Cal,


Thank you again for your help.


Prior to applying the conditional formatting rule you gave me, I had another one applied to shade every other row. I used the following conditional formatting rule/formula: =MOD(Row(),2


Now because of my shading rule, the dates do not highlight on the shaded rows.



Do you know if there's a work-around so I'm able to use both rules?


Thank you in advance.