Conditional formatting only applies to one row

[ASH92]

Hi all,

I've managed to apply conditional formatting to a whole row $A$2:$J$2 based on the value of $H$2. However I need this to apply to every row in the spreadsheet - please help!

So My H column is a drop down options column, and I want the rows to be highlighted if their H cell has a "YES". Please see the first rule in the screenshot below. As it stands, it only uses and formats the values in row 2, but I want the same rule to apply to each rule (where row 3 would turn green if H3 is YES, etc.)

I'd really appreciate your help!

 

[Joe4]

Welcome to the Board!

You would first select the ENTIRE range to apply it to (i.e. A2:J100000).
Then, in your formulas, make sure that you do NOT lock the row references, so each row will look at the values in the columns in those particular rows, i.e.
the formula:

=($H$2="YES")

should just be:

=$H2="YES"

(note we removed the "$" before the row number "2").

 

[ASH92]

Welcome to the Board!

You would first select the ENTIRE range to apply it to (i.e. A2:J100000).
Then, in your formulas, make sure that you do NOT lock the row references, so each row will look at the values in the columns in those particular rows, i.e.
the formula:

=($H$2="YES")

should just be:

=$H2="YES"

(note we removed the "$" before the row number "2").

Thanks, you absolute legend!

So I highlighted the whole spreadsheet and changed the CF to this:

Before this final change, I followed your instruction but had $H2 instead of $H1 and it was highlighting the row above instead of the row with the value for the CF.

It's all now resolved, thanks Joe

 

[Joe4]

Thanks, you absolute legend!

So I highlighted the whole spreadsheet and changed the CF to this:
View attachment 95994

Before this final change, I followed your instruction but had $H2 instead of $H1 and it was highlighting the row above instead of the row with the value for the CF.

It's all now resolved, thanks Joe

You are welcome.

Yes, the formula you enter has to match the FIRST cell in your applied to range, or else you will be shifted off by a row.
So if the first cell in your applied to range is row 1, then the formula you enter has to reference row 1.