Conditional Formating or IF Function

[Alexa M.]

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?

 

[Pete_UK]

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

 

[Jim Thomlinson]

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

 

[ckane]

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.