I am very new to using excell formulas. Can anyone please
tell me how to write a formula that will automatically
turn red any date that is six months away or less?? I
have learned alot of things lately, but this escapes me!

select the cells you want to have this behavior

Assume you select B5:B50

then do format=Conditional Formatting

change the second dropdown to

between

in the next textbox put in

=Now()

in the last textbox put in

=Now()+180

then click the format button, select the pattern tab and click red

then OK you way out.

--
Regards,
Tom Ogilvy

Sean wrote in message
...
I am very new to using excell formulas. Can anyone please
tell me how to write a formula that will automatically
turn red any date that is six months away or less?? I
have learned alot of things lately, but this escapes me!