| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell auto filling with colour
I have a worksheet that contains no.'s 1-4. I currently fill the colours
myself, but it's hectic. I need the cells to auto fill with colour when I enter the no. I need to use the colours yellow, orange, green and red. but when i change the value of the cell, it must auto change to the specified colour. 1=green, 2=yellow, 3=orange, 4=red |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell auto filling with colour
use Conditional Formatting in Format Menu.
"Ruggy" wrote: I have a worksheet that contains no.'s 1-4. I currently fill the colours myself, but it's hectic. I need the cells to auto fill with colour when I enter the no. I need to use the colours yellow, orange, green and red. but when i change the value of the cell, it must auto change to the specified colour. 1=green, 2=yellow, 3=orange, 4=red |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell auto filling with colour
I tried that, but I can only get three colours
"Ashkan" wrote: use Conditional Formatting in Format Menu. "Ruggy" wrote: I have a worksheet that contains no.'s 1-4. I currently fill the colours myself, but it's hectic. I need the cells to auto fill with colour when I enter the no. I need to use the colours yellow, orange, green and red. but when i change the value of the cell, it must auto change to the specified colour. 1=green, 2=yellow, 3=orange, 4=red |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell auto filling with colour
Set one colour for cell and use conditional formatting for others
"Ruggy" wrote: I tried that, but I can only get three colours "Ashkan" wrote: use Conditional Formatting in Format Menu. "Ruggy" wrote: I have a worksheet that contains no.'s 1-4. I currently fill the colours myself, but it's hectic. I need the cells to auto fill with colour when I enter the no. I need to use the colours yellow, orange, green and red. but when i change the value of the cell, it must auto change to the specified colour. 1=green, 2=yellow, 3=orange, 4=red |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell auto filling with colour
Thanx so much, Ashkan. you helped me big time
"Ashkan" wrote: Set one colour for cell and use conditional formatting for others "Ruggy" wrote: I tried that, but I can only get three colours "Ashkan" wrote: use Conditional Formatting in Format Menu. "Ruggy" wrote: I have a worksheet that contains no.'s 1-4. I currently fill the colours myself, but it's hectic. I need the cells to auto fill with colour when I enter the no. I need to use the colours yellow, orange, green and red. but when i change the value of the cell, it must auto change to the specified colour. 1=green, 2=yellow, 3=orange, 4=red |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto change cell text colour resulting from a condition | Excel Worksheet Functions | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Update Macro: Leave Colour As Before Once Cell is Not Active | Excel Discussion (Misc queries) | |||
| SQL - Auto Refresh Upon Cell Value Change | Excel Worksheet Functions | |||
Linear Mode
