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.
[link] [comments]
Want to read more?
Check out the full article on the original site