Printable View
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
Quote:
=$I6<=TODAY()
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.
Should have had a play for just a little longer before i posted
Addingas a second conditional rule as solved this.Quote:
=AND($I6<TODAY(),$I6>TODAY()-356)
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?
lol i figured that one out aswell. I'm going to shutup now :)