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?
4 Replies
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.
