Cell Color change

P

picktr

How do I get a cell to change color automatically?

The cell already calculates a SUM, but I also need it to
look at a range of cells and if its value is > than the rest, chang
color.


To
 
R

rodolform

You could use conditional format.
Go to Format > Conditional format and then select formula. and the
select format, there you can chose the color of the cell yoou what whe
the criteria in the formula is meet
 
B

Bob Phillips

Sounds like conditional formatting

I think you want max, so select all the cells
Goto Format>Conditional Formatting
Change Condition1 to Formula Is
Add a Formula of =A1=MAX($A$1:$A$10)
Click Format and select a colour from the pattern tab
Exit

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
P

picktr

Bob,

That one works. Thanks.

One more.

How would I change it to only color
the range of cells whose value is the lowest
not including "0
 
Top