I want to change the cell format (color) based on a calc

  • Thread starter Thread starter mtnmanus
  • Start date Start date
M

mtnmanus

I have a spreadsheet with due dates and current date - I want to change the
status on those tasks based on calculation of due date against current date.
If due date has passed - I want to turn cell "red", if not passed thenn
"green" if same day then "yellow".
How can I do this?
thanks !
 
Take a look at condtional formatting

Format -> Conditonal Formatting

Use the Today() function to get the current date.
 
Hi

Check out Conditional formatting.

Cond. form. together with dates has been dealt with many times in the
earlier newsgroup postings, so you can use the search function and you will
surely find your solution. If not, please ask further.
 
Assuming the due date is in cell A1...

Select cell A1
Goto the menu Format>Conditional Formatting
Select the Formula Is option
Condition 1 (due date expired - RED)
Enter this formula in the little box on the right:
=AND(COUNT(A1),A1<TODAY())
Click the Format button
Select the Patterns tab
Select a nice shade of RED>OK

Click the Add button
Condition 2 (due date is today - YELLOW)
Formula Is: =A1=TODAY()
Click the Format button
Select the Patterns tab
Select a nice shade of YELLOW>OK

Click the Add button
Condition 3 (due date is in the future - GREEN)
Formula Is: =AND(COUNT(A1),A1>TODAY())
Click the Format button
Select the Patterns tab
Select a nice shade of GREEN
OK out
 
Back
Top