| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
i want cells to auto fill with colour when i enter a number
ie, when entering data into a speadsheet if 1 entered 1 the cell would go
red, 2 orange etc |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
i want cells to auto fill with colour when i enter a number
hi,
you can use conditional formating for up to 3 colors. if you want more you will have to use a macro using the worksheet change event. regards FSt1 "zoe" wrote: ie, when entering data into a speadsheet if 1 entered 1 the cell would go red, 2 orange etc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
| Want a number of cells to be auto completed based on entry in one. | Excel Worksheet Functions | |||
| How do I auto number cells in an Excel template? | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Linear Mode
