Conditional Formatting (How to format a range depending on another range)

  • Thread starter Thread starter Josh Rogers
  • Start date Start date
J

Josh Rogers

I'd like to format Columns C, D, E, F, and G based on whether their
cell content is greater than the cell in the same row in column B.

It seems that the conditional format is always based on a single cell,
not a range like this. Can anyone explain to me how to accomplish
this?

Thanks so much for your time and knowledge,
Josh
 
Just make sure you "anchor" your formula.

I selected C2:G99 and with C2 the activecell
I applied format|conditional formatting
I used a formula of: =c2>$b2

The $b tells excel to always look at column B.
No $ in front of the 2 means that excel will adjust it for the other rows.
 
Back
Top