• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting of Rows in a Range

fred3

Member
I want to color shade each row in a range of rows according to values in each row:
IF (AND(Bx="",Hx=1) then shade gray ELSE shade white.
 
Hi @fred3,
Conditional formatting is easy: it works when the formula used returns true. So... in CF use AND($B2="",$H2=1) , applied to the range you need.
 

Attachments

  • CF_greyorwhite.xlsx
    8.6 KB · Views: 3
So, does one have to enter a particular row formula for each row? That's how this appears. I have too many rows to justify doing that.
 
Nope! I only enter one formula with relative row references (no "$" before the row references). This is rather basic Excel...
 
Back
Top