A
Alexa M.
How do I conditional format a date?
The date should be thirty one days old when it formats.
The date should be thirty one days old when it formats.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
W
Wigi
If it's about cell A1:
Cond. formatting
"Value is"
less than
today()-31
Cond. formatting
"Value is"
less than
today()-31
W
Wigi
Bad sentence: disregard from: "If it's about cell A1:"
The rest should be OK.
The rest should be OK.
A
Alexa M.
Does this work in the newer version of Excel? If you could you please give
step by step instructions?
step by step instructions?
A
Alexa M.
Also would the if function work in the same way?
M
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?
format when it is >31 days from day x? Is day x a specific cell reference or
is it the current date?
A
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.
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.
A
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"
-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"