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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top