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

Tagged with

#rows.com
#AI formula generation techniques
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#conditional formatting
#date reference
#start date
#end date
#formatting formula
#cells
#highlighted cells
#dragged down
#working
#column
#correct
#example
#img
#cell formatting
#Excel