Conditional Formating or IF Function
 

What I want to do is, when I open up excel I want a date to change colour if
it is overdue (Ie thirty-one days from the invoice date). Would I use
conditional formating or would the IF Function be better suited for this?
--
Alexa

Conditional Formating or IF Function
 

An IF function cannot be used to change a colour, so you will have to
use conditional formatting. Select the cell(s) that you want this to
apply to and click on Format | Conditional Formatting and in the first
box choose Formula Is rather than Cell Value Is. In the next box you
will need to enter a formula something like:

=TODAY()D1+30

where I have assumed that the invoice date is in column D and the
first cell highlighted is in row 1 - adjust to suit your set-up.

Then click on the Format button, select the Patterns tab and choose
the colour you want to use. Click OK twice to exit the dialogue boxes.

Hope this helps.

Pete

On Jul 23, 4:15*pm, Alexa M. wrote:
What I want to do is, when I open up excel I want a date to change colour if
it is overdue (Ie thirty-one days from the invoice date). Would I use
conditional formating or would the IF Function be better suited for this?
--
Alexa

Conditional Formating or IF Function
 

You would use conditional formatting. Assuming you do not want to format the
cell if it is balnk they use a formula similar to this...

=AND(A1<=NOW() - 30, A1<"")
otherwise you can just use Cell value is and choose less than or equal to
and add
=NOW() - 30
--
HTH...

Jim Thomlinson


"Alexa M." wrote:

What I want to do is, when I open up excel I want a date to change colour if
it is overdue (Ie thirty-one days from the invoice date). Would I use
conditional formating or would the IF Function be better suited for this?
--
Alexa

Conditional Formating or IF Function
 

Use conditional formating.

The formula is assuming A1 is the cell you need formatting.

Formula is =(A1-Today())<31

Make sure you format the cell in the conditional formatting menu.

"Alexa M." wrote:

What I want to do is, when I open up excel I want a date to change colour if
it is overdue (Ie thirty-one days from the invoice date). Would I use
conditional formating or would the IF Function be better suited for this?
--
Alexa