| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i automate colour to fill a cell if a range of data is inp
I would like for a cell to automatically fill with a colour if numbers 1-3
are entered into the cell. Then another colour if numbers 4-6 are entered, and yet another if 7-9 is entered. can anyone help? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i automate colour to fill a cell if a range of data is inp
You can acheive this using Conditional formatting. Refer
http://www.contextures.com/xlCondFormat01.html -- If this post helps click Yes --------------- Jacob Skaria "Lainey25" wrote: I would like for a cell to automatically fill with a colour if numbers 1-3 are entered into the cell. Then another colour if numbers 4-6 are entered, and yet another if 7-9 is entered. can anyone help? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell colour fill | Excel Discussion (Misc queries) | |||
| Changing fill colour of cells in a range | Excel Discussion (Misc queries) | |||
| can the fill colour of a bar be tied to the data font colour data | Charts and Charting in Excel | |||
| Fill a cell with a data range | Excel Programming | |||
| Changing Cell Fill Colour | Excel Discussion (Misc queries) | |||
Linear Mode
