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

Conditional Formatting Issue Between Dates

Hello all,

Fully admitting I am not the best at Excel so be nice please.

I am using a spreadsheet in my job that I use to track dates for service users.

I have a column for any time that a user has received a piece of paperwork.

If it has been beyond 90 days then I have the conditional Formatting set to a green background. The formatting for this is cell value > less than > today() -90

The issue is when I'm trying to have a red background for any paperwork submitted within those 90 days. I had this already formatted with cell value > between > today > today() -90

This worked up until today. I put in a value for a few days ago and the background has turned white instead of red and I can't seem to fix it.

Any help would be greatly appreciated.

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#rows.com
#modern spreadsheet innovations
#self-service analytics tools
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#real-time data collaboration
#financial modeling with spreadsheets
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#Conditional Formatting
#Excel
#dates