conditional colour of cell

[Guest]

How do i get a cell to be particular colour if sum in cell => than a number
and if not, then assign another colour. New to this so any help appreciated.

 

[JW]

Format-->Conditional Formatting
"Cells Value Is" - "Greater than or equal to" - whatever your number
Click on the Format button and make any changes you desire.
To add a second condition, click the Add button.
You are limited to 3 conditions.

 

[Chip Pearson]

Use Conditional Formatting from the Format menu. It will do exactly what you
want. See www.cpearson.com/Excel/CFormatting.htm for additional details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Guest]

Format-->Conditional Formatting
"Cells Value Is" - "Greater than or equal to" - whatever your number
Click on the Format button and make any changes you desire.
To add a second condition, click the Add button.
You are limited to 3 conditions.
Thanks, simple once you know.