Conditional Formatting: if date value (x) is greater/less then percentage (y) then the cell color changes

[goodmachine]

I have a conditional formatting question regarding dates. Below are the two scenarios:

• If the values in column H have passed (e.g., 12/01/2012), fill the cell in red. I tried to do this with the Conditional Formatting under Highlight Cell Rules > A Date Occurring, but it didn't work for any of the selections for the past.
• If the values in column H are approaching 30 days from the effective end date (e.g. today is 2/5/14 and the effective end date is 3/7/2014), fill the cell with orange.

Any help is appreciated. Thank you.

 

[Momentman]

For the first part, do you mean anyday before today, if thats what you mean, then in conditional formatting, For some reason, i cant post the formula as is here. hence

Excel 2010
	B
13	TRUE
Sheet16

Cell Formulas
Range	Formula
B13	=$H1)

<todday()[ code]<today()[="" code]<today()<today()<="" html=""></todday()[>

 

[goodmachine]

Yes, any day before today's date. It could be a day in 2012, 2/3/2014, etc. Thank you.

 

[Momentman]

Approaching 30 days? You have to be more specific, maybe from 28 days to 30 e.t.c