Conditionally format a range based on a different range

Question

Given the sheet:

A| B | C = SUM($D2:$Z2) | D | E | F | ...

How would I, for a range of rows (for example: 4:50), color columns Cx:Zx (for row x) if Bx > Cx, without making a conditional rule for each individual row and/or each individual column?

(Assume there are a lot of rows and a lot of columns.)

Answer 1

There are several Q&A on Stackoverflow that would assist you. In particular Conditional formatting based on another cell's value and the answer (with the attached comments) by Zig Mandel. It's a reminder that some Googling is always worthwhile before asking a new question.

• Select "Custom formatting" from the Format menu.
• Set "Apply to Range" to C2:Z50
• "Format cells if", select "Custom formula is" and enter =$B2:$B>$C2:$C
• Select Done.

---

B is less than C

---

B is greater than C

Screen shots