Help with conditional formatting

[randle]

I have an excel table that i want to apply some conditional formatting to.

I would like it so that if a value (any value) is added to cell I6, the other cells font colour changes. The formula i have below does the job but also applies this formatting if there is no entry present in cell I6. I only want this to happen if something is entered into this cell. Can anyone help

=$I6<=TODAY()

[randle]

A little more playing about and i've made progress if i remove "<" from the formula this doesn't apply if there is nothing present in this cell but now it's just applying if todays date is entered. I want this to apply if any date is entered today or past. That's why i was trying to figure out if this could be triggered by any value entered in the cell.

[randle]

Should have had a play for just a little longer before i posted

Adding

=AND($I6<TODAY(),$I6>TODAY()-356)

as a second conditional rule as solved this.

Now i just need to find out how to apply this same formatting to all the rows in my table without having to do each one manually. Anyone?

[randle]

lol i figured that one out aswell. I'm going to shutup now