Thread: cell colours to change according to totals
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default 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

Reply With QuoteReply With Quote