cell colours to change according to totals
 

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
--
Shane A. Cawthorn

cell colours to change according to totals
 

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

Hope this helps.

Pete

On Jan 29, 3:49*pm, Shane wrote:
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
--
Shane A. Cawthorn