•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional Formating with dates
I am trying to automatically highlight cells where the date in the cell falls within certain criteria.
Example: A report was received on Date "A". The due date is "B". I am trying to auto fill the cell with color if the date is 1-2 months past B, 3-5 Months past B, and 6+ months past B. For the life of me I cannot figure out how to do this.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Conditional Formatting
#dates
#highlight cells
#Excel
#criteria
#due date
#auto fill
#color
#months past
#report received
#timeframe
#automated highlighting
#thresholds
#date calculation