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.

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.

Dutchy wrote:
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.

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)


"Dutchy" wrote in message
...
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" wrote:

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.
Dutchy wrote:
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.