•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional Formatting for Dates within 30 days or past due- needs to account for the year!
Hi there,
Trying to get cells to change to orange if they have an expiration date within the next 30 days or red if they are already expired. I have tried every formula I can find but I need the formula to take the year into account, since many of our supplies don't expire until the next year. If I need to use a helped column I can do that as well, but if possible to do it without one that would be even better.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#Excel alternatives for data analysis
#formula generator
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#Conditional Formatting
#Expiration Date
#Formula
#30 Days
#Year
#Cells
#Excel
#Orange Color
#Red Color
#Change Color
#Date Calculation
#Helped Column