Change row color if value in a cell

[Solved/Closed]
Report
-
Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
-
Hello,

I've tried so many variations and cant get it right. All I want is an entire row (A:H) to be highlighted yellow if there is ANYthing entered in column H. I've tried conditional formatting and cant get the entire row yellow (it turns A:G yellow, but not H) or it does the opposite and only column H turns yellow and not the whole row, or it only highlights the whole row if there is nothing in column H!!

This is what I've tried:

cell value is: equal to: =$H1="1" (this only highlights column H and not whole row)

Please help, thank you.


Edit: Finally got it right:

Formula is: =not(isblank($H2))


Thanks to: https://www.excelforum.com/excel-formulas-and-functions/568947-change-row-colour-when-a-value-is-given-in-a-cell.html

1 reply

Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
487
Hi,

Thanks for sharing with us the solution you have found.

Best regards
5
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month