Change condition in cell

  • Thread starter Thread starter Catfish
  • Start date Start date
C

Catfish

I would like to automatically have a cell change color if it is the largest
number.
For instance:
B1=22
B2=24
B3=30
B4=15

Since B3 is the most, I would like for it to turn RED for instance.
I can't think of the proper conditional format. Anyone?

Thanks!
 
Yes, this is CF.
if cell a1 then
format>conditional format>left window formula is> right window
=a1=max(a:a)>format as desired>use format painter to copy to other cells.

Your private question to me.
Don, thank you for your fast reply and help to my problem.
This is really over my head I guess. Is this formula to be
copied over the cells or is it a conditional format etc..?
Out of a column of numbers, I want the highest value to
change to red color if possible.
 
You must log in or register to reply here.

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

Similar Threads

find oldest date with a condition 4
Stop duplicate data 1
Need Help with a Formula 4
Data Validation and drop-down list using IF, AND and what else? 8
Need help with a formula 8
copying a conditional format gives the whole range 3
Excel 2007 - Conditional Formatting copy/paste errors 2
conditional format 3

Back
Top