I need to change the BG color of a cell dynamically
 

I have a spread sheet that has monthly totals, projected and actual, I
need the actual amount totals bg color to change to red or green
depending upon if the actual was over the projected or under, I also
need it to change to blue if the totals are equal.

Example: June projected total was 300, actual total was 400, I need to
have the BG of the actual change to green because it was over 300.

What would I use to accomplish this?

I need to change the BG color of a cell dynamically
 

You can use Conditional Formatting from the Format menu to do
this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Degobah" wrote in message
om...
I have a spread sheet that has monthly totals, projected and
actual, I
need the actual amount totals bg color to change to red or
green
depending upon if the actual was over the projected or under, I
also
need it to change to blue if the totals are equal.

Example: June projected total was 300, actual total was 400, I
need to
have the BG of the actual change to green because it was over
300.

What would I use to accomplish this?

I need to change the BG color of a cell dynamically
 

I would try conditional formatting
It's under Format on the menu bar and allows up to 3
conditions.


-----Original Message-----
I have a spread sheet that has monthly totals, projected
and actual, I
need the actual amount totals bg color to change to red
or green
depending upon if the actual was over the projected or
under, I also
need it to change to blue if the totals are equal.

Example: June projected total was 300, actual total was
400, I need to
have the BG of the actual change to green because it was
over 300.

What would I use to accomplish this?
.