Highlighting Dates in Excel 2007

[Sssy]

Hi everyone,

I really hope someone can help me. I have an intermediate user level of the Word packages but very rarely need to use advanced formulas or macros so I don't really know too much about them.

I have been asked to make one of our spreadsheets highlight (in two different colours) both existing dates that are overdue (in red) and dates that fall within the next 2 weeks (amber/orange).

Can anyone please help me?

 

[Hui]

Sssy


Firstly, Welcome to the Chandorg Forums


Conditional Formatting to your rescue


Assume your range is A1:A20

Select the Range

Conditional Formatting (CF)

New Rule

Use a Formula

=A1<Today()

Set Format To Red


add another CF


Select the Same Range

Conditional Formatting

New Rule

Use a Formula

=and(A1>-Today(),A1<=(Today()+15))

Set Format To Orange


I'd recommend having a read of:

http://chandoo.org/wp/2009/03/13/excel-conditional-formatting-basics/

http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/

 

[Sssy]

Fantastic, thank you for your speedy response, Sir Ninja ... Just tried this, verbatim, and the first rule worked well, until I added the second rule, now it's all turned orange instead ... hmmmmm ... I be mucho confusedo ... >@

 

[Hui]

Select the same area

Goto CF

Manage CF

It should list 2 CF's

Rearrange the order that the CF's are in


and you read the 2 links I posted ?

 

[Sssy]

You, my dear man, are a legend! I kinda only skim read the links as I have a mountain of work, but will read them through properly when I get home tonight (sad sad life ... *sigh*). I did as suggested & it all worked beautifully!

Thanks again!