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" <(E-Mail Removed)> wrote in message
news:F95A54AB-EDAB-4AC7-AB21-(E-Mail Removed)...
> 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.
>
>