color code

S

Shihachi

I have trying to do this, but to no avail.
I want cells to change color like:
more than 60 days before certain date - they're green
1 - 60 days - they're yellow
0 days and days after - they're red
 
J

Jim Thomlinson

Format | Conditional Format | Cell Value is < A1-60 where the date to check
against is in cell A1. Define your Format.

Same for the other formats
 
S

Shihachi

i use excel 2007

Jim Thomlinson said:
Format | Conditional Format | Cell Value is < A1-60 where the date to check
against is in cell A1. Define your Format.

Same for the other formats
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countdown macro - display settings 2
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Conditional formula 1
Conditional formatting with dates 7
Conditional formatting with two columns 0
Conditional Formatting, Date Ranges and Rows 2
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
Need help modifying code 0

Top