Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional fill
Similar to conditional font, is there a way to specify a cell fill if for
example cell value was 1, the fill would be green, if 2 then yellow, if 3 then red? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional fill
Yes, this can be done. Goto FORMAT CONDITIONAL FORMAT. Use the "Cell
Value Is" option and the choose "equal to" in the next prompt. The last prompt is what you want the cell value to equal. You can have up to 3 conditional formats. For the first one, the will be 1. Then click on FORMAT Pattern and choose your color. After clicking OK, then click on ADD to add the 2nd and 3rd conditions. Les "Pa Maher" wrote: Similar to conditional font, is there a way to specify a cell fill if for example cell value was 1, the fill would be green, if 2 then yellow, if 3 then red? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating & Fill Effect | Excel Discussion (Misc queries) | |||
Conditional Auto fill | Excel Discussion (Misc queries) | |||
Conditional cell auto fill | Excel Worksheet Functions | |||
Conditional formatting -- copy paste special won't change referenc | Excel Discussion (Misc queries) | |||
Conditional formatting: Colour coding | Excel Discussion (Misc queries) |