Conditional Formatting - Whole Row

[ChrisFoster]

Hi,

I want to use the below formula in conditional formatting to highlight the whole row when the date in column I is before today's date. Currently it only highlights the cell in column I rather than the whole row, how do I get it to show whole row please?

=AND(COUNT($I3:$I3),MIN($I3:$I3)<TODAY())

 

[Joe4]

That because you currently only have the rule applied to column I.
Apply it to the whole row, and as long as you use the "$" before the column references in your Conditional Formatting formula, it will look those in your formula so that every column in your row is looking at the same formula. It looks like you have done that, so you just need to change the range you are applying it to.

 

[ChrisFoster]

That because you currently only have the rule applied to column I.
Apply it to the whole row, and as long as you use the "$" before the column references in your Conditional Formatting formula, it will look those in your formula so that every column in your row is looking at the same formula. It looks like you have done that, so you just need to change the range you are applying it to.

View attachment 88637

Sorry, I'm being stupid here but what do I change =$I:$I to?

 

[Joe4]

Row numbers instead of column letters.