#### garretttpe

##### New Member
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

### Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Try

=(H6-30)>TODAY()

=(H6-14)>TODAY()

=H6<=TODAY()

Code:
``````[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]``````

Try

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

Last edited:
Try

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

Think it should be -14 & -30

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?

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

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

See my last post.

Replies
5
Views
606
Replies
5
Views
551
Replies
11
Views
6K
Replies
9
Views
365
Replies
7
Views
648

1,203,631
Messages
6,056,432
Members
444,864
Latest member
Thundama

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back