| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up automatic colour fill of a cell prompted by text?
A column in a spreadsheet shows the staus of each project. The cells are
colour coded to clearly show the status eg. Red = Overdue, Green = Complete etc.. Is it possible to prompt the cell to colour automatically by entered text eg. Type Overdue and the cell automatically turns red? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set up automatic colour fill of a cell prompted by text?
GEM wrote: A column in a spreadsheet shows the staus of each project. The cells are colour coded to clearly show the status eg. Red = Overdue, Green = Complete etc.. Is it possible to prompt the cell to colour automatically by entered text eg. Type Overdue and the cell automatically turns red? Hi, Maybe you can use Conditional Formatting. Highlight the column with status of the projects. Go to Format - Conditional Formatting. Under Condition 1 chose Cell Value Is - egual to and type Overdue. Clik Format - Patterns chose Red and clik OK. Now Clik Add and repeat the above just with Complete and Green. Regards, Bondi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change the colour of text in cell for minus figure | Excel Worksheet Functions | |||
| Criteria - Automatic Change Font or Fill Colour | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
| Changing Cell Fill Colour | Excel Discussion (Misc queries) | |||
Linear Mode
