Cell Color change

[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

 

[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

 

[Ron de Bruin]

Look at CF
http://www.contextures.com/xlCondFormat01.html

Post back if you need help

 

[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)

 

[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