Conditional Formating

[Alexa M.]

How do I conditional format a date?

The date should be thirty one days old when it formats.

 

[Wigi]

If it's about cell A1:

Cond. formatting
"Value is"
less than
today()-31

 

[Wigi]

Bad sentence: disregard from: "If it's about cell A1:"

The rest should be OK.

 

[Alexa M.]

Does this work in the newer version of Excel? If you could you please give
step by step instructions?

 

[Alexa M.]

Also would the if function work in the same way?

 

[M Kan]

I don't quite understand the question. Are you trying to make a date change
format when it is >31 days from day x? Is day x a specific cell reference or
is it the current date?

 

[Alexa M.]

I want the date to change to red when the invoice (which it really is an
ivoice) is over thrity days old. Which would mean that the customer for the
invoice is overdue. I want to see who is over due when I open up the workbook.

I don't know I think it would be a cell reference.

 

[Amylou]

Try this:

-highlight your column
-go to "format"
-go to "conditional format"
-condition 1: cell Value Is less than today()-31
-go to "format"
-choose your font, font color and background color, click "OK"
-click "OK"