•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to use TODAY() to conditionally format due dates?
I am a complete noob at excel so my apologies if this is very easy.
Essentially, I am trying to make a column where I write the last date I received records. I’m supposed to get updated records at least once every 90 days, but frequently they’re late. I want the cell to turn red if the date in it is older than 90 days. The column is K and the first cell with info is K2.
I tried =K2<TODAY()-90 and =$K$2<TODAY()-90, but the test dates I tried either don’t turn red when they should or *all* of them turn red even if left blank.
What formula should I use?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#AI formula generation techniques
#financial modeling with spreadsheets
#formula generator
#TODAY()
#excel
#formula
#conditional formatting
#due dates
#90 days
#last date
#K column
#turn red
#updated records
#cell color
#cell reference
#blank cell