Forum Discussion
Color Coding by Date
I am trying to build a spreadsheet that automatically color fills a date cell by whether the date has already past (red), is within 7 days (yellow), or further out than 7 days (white). I've tried using the Conditional formatting, but I must not be doing it correctly, as it doesn't color code anything, or color codes everything red. Any help?
Hi Timothy,
In general CF shall work for your case. If you explain in more details which rules you use or , even better, submit some sample file, it'll be easier to answer what's wrong.
Here's the sheet I was working on. I want dates prior to whatever the current date us to be red, those within 7 days to be yellow, and those more than 7 days out to remain white. It should color code depending on the current day, not the day I'm building it.
Hi Timothy,
You need two rules
red one
=($A3<=TODAY())*($A3>1)
where the second part excludes blank cells; for yellow
=($A3<=TODAY()+7)*($A3>1)
Rules are in sequence as above. The rest, i.e. TODAY()+7 will be blank. File is attached.
