cell colours to change according to totals

  • Thread starter Thread starter Shane
  • Start date Start date
S

Shane

Hi

Can the following be done: When with calculating a total between two
amounts, the cell must automatically change to a cetain colour wanted. eg:
totals between 150 and 200 the cell must change to RED or : 201 to 250 the
cell must automatically change to blue.

THANKS
 
You would use conditional formatting to do this - available from the
Format menu.

Hope this helps.

Pete
 
Back
Top