| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Really basic question! Cell colours change when emailed. | Excel Discussion (Misc queries) | |||
| Don't change cell colours when adding or deleting rows? | Excel Discussion (Misc queries) | |||
| is there a formula to auto change cell colours | Excel Discussion (Misc queries) | |||
| Excel will not change cell border colours | Excel Discussion (Misc queries) | |||
| automatically change cell colours | Excel Discussion (Misc queries) | |||
Linear Mode
