• 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


  • 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


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.


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