1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Conditional formatting date reference between Start and End date

I set cond formatting in O7 as my starting point with formatting formula as seen below. I dragged it down the column, and then over, and it seems to work in some cells but not others. Highlighted cells as example of where it's not working. How do I correct this? Thank you!

*F7 is Start Date, G7 End date in case it doesn't show in the enlarged img.

https://preview.redd.it/xip2y1v413lg1.png?width=2015&format=png&auto=webp&s=d0e04eb506d9e005bd19f18d48e9b4d702d01cb7

submitted by /u/AggressiveInitial630
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article