Help with a formula

  • Thread starter Thread starter Sean
  • Start date Start date
S

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!
 
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.
 
Back
Top