Help with a formula

[Sean]

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!

 

[Tom Ogilvy]

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.