• 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.
 

fred3

Member
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.
 

GraH - Guido

Well-Known Member
Nope! I only enter one formula with relative row references (no "$" before the row references). This is rather basic Excel...
 
Top