cell colours to change according to totals

[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

 

[Pete_UK]

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

Hope this helps.

Pete