Conditional formatting help please

[garretttpe]

Hi All

cell G6 = calibration date 6/6/2014
cell h6 = calibration due date 6/6/2015

I need H6 to turn grey when 30 days prior to it
I need H6 to turn yellow 14 days prior to it
I need H6 to turn red on the due date.

I have tried many different things using the =now()+30 and different combination and I am unable to get it to work.
I am using excel 2010.

thank you all for any help in this

Larry

 

[gaz_chops]

Try

=(H6-30)>TODAY()

=(H6-14)>TODAY()

=H6<=TODAY()

 

[gaz_chops]

Oops made a mistake!

[TABLE="width: 97"]
<tbody>[TR]
[TD]=H6 < =TODAY()[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]=(H6-14) < TODAY()[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]=(H6-30) < TODAY()[/TD]
[/TR]
</tbody>[/TABLE]

 

[mas123]

Try

=H6 < =TODAY()
=(H6+14) < TODAY()
=(H6+30) < TODAY()

 

[gaz_chops]

Try

=H6 < =TODAY()
=(H6+14) < TODAY()
=(H6+30) < TODAY()

Think it should be -14 & -30

 

[garretttpe]

Thanks
it is working fine except I would like this to happen to all cells in column H, when I try to use =(H6:h36-30)<today() it does not work. Inputing what I need in each cell will take me forever. is there a way to make each cell in the row do what I need above?

 

[gaz_chops]

Highlight the range H6:H36, then apply the cond format to H6.

 

[garretttpe]

my last post got cut off

how do I copythe conditional format above to work on all cells in Column H, I tried doing =(h6:h36-30)<today() but that does not work. typing in the formula in every cell will take for ever.

thanks

 

[gaz_chops]

See my last post.