View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Degobah Degobah is offline
external usenet poster
 
Posts: 1
Default 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?