Conditional Formating
 

How do I conditional format a date?

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


--
Alexa

Conditional Formating
 

If it's about cell A1:

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



--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Alexa M." wrote:

How do I conditional format a date?

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


--
Alexa

Conditional Formating
 

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

The rest should be OK.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Wigi" wrote:

If it's about cell A1:

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



--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Alexa M." wrote:

How do I conditional format a date?

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


--
Alexa

Conditional Formating
 

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


"Wigi" wrote:

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

The rest should be OK.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Wigi" wrote:

If it's about cell A1:

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



--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Alexa M." wrote:

How do I conditional format a date?

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


--
Alexa

Conditional Formating
 

Also would the if function work in the same way?
--
Alexa


"Alexa M." wrote:

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


"Wigi" wrote:

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

The rest should be OK.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Wigi" wrote:

If it's about cell A1:

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



--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Alexa M." wrote:

How do I conditional format a date?

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


--
Alexa

Conditional Formating
 

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?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Alexa M." wrote:

How do I conditional format a date?

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


--
Alexa

Conditional Formating
 

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.
--
Alexa


"M Kan" wrote:

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?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Alexa M." wrote:

How do I conditional format a date?

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


--
Alexa

Conditional Formating
 

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"

"Alexa M." wrote:

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.
--
Alexa


"M Kan" wrote:

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?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Alexa M." wrote:

How do I conditional format a date?

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


--
Alexa