Conditional Formatting | Dragging to other Cells

[jmancha]

Hello!

I have a very simple conditional format: =$I2>1/1/1900. Basically if I2 has a date greater than1/1/1900 then I want H2 to not have any fill and for the font to be regular. I have other conditional formatting in H2 to tell me if the date is expired.

This works great BUT when I drag to row 3 the I2 does not change to I3.

Suggestions?

 

[Fluff]

If you select H2 to the last row in H, there is no need to "drag" it down.
Also the formula will still show $I2, but it will work on I3, I4 etc.