***Conditional Formatting Multiple Cells***

  • Thread starter Thread starter Alicia
  • Start date Start date
A

Alicia

Now that I have figured out how to conditionally format one cell, how do I
format multiple cells in the same manner? I've tried using the formatter
"paintbrush" and that just turned all the cells in the column red instead of
those that match the formula.

Formula - if column C is less than column H make that cell red.
 
Post the *exact* formula you used.

I'll bet your problem is the mis-use of absolute and/or relative references.
 
Back
Top