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