Change row color if value in a cell

Solved/Closed
mirror - Jul 10, 2010 at 11:10 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Jul 10, 2010 at 01:48 PM
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
Related:

1 response

aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
Jul 10, 2010 at 01:48 PM
Hi,

Thanks for sharing with us the solution you have found.

Best regards
5