| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How I auto fill a cell patern or color based on a pick list?
Hello,
Attempting to auto fill a cell with a color based on a selected word or value in a pick list. example: If selecting Tuesday the Cell would be blue, Monday the Cell would be Yellow, etc.. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How I auto fill a cell patern or color based on a pick list?
Try Format / Conditional Formatting
"bbjr" wrote: Hello, Attempting to auto fill a cell with a color based on a selected word or value in a pick list. example: If selecting Tuesday the Cell would be blue, Monday the Cell would be Yellow, etc.. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How I auto fill a cell patern or color based on a pick list?
Thanks Ken-hup
Apparently your only able to apply one conditional format to a cell. What I'm trying to do is have a cell called day, if that cell value is Monday it's pattern would be Blue, If Cell value = Tuesday then Green, etc.. It's the same cell, just a different value and patern color I want to change based on that value. Thoughts? Bob "ken-hup" wrote: Try Format / Conditional Formatting "bbjr" wrote: Hello, Attempting to auto fill a cell with a color based on a selected word or value in a pick list. example: If selecting Tuesday the Cell would be blue, Monday the Cell would be Yellow, etc.. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How I auto fill a cell patern or color based on a pick list?
Depending on which excel you are using, I currently am using 2003 -
Try this colour all cells one colour (e.g. Purple) select column go to Format / Conditional formatting. In box 1 Cell Value is in box 2 equal to in box 3 Monday Select Format and choose colour (e.g Yellow) Now click ADD to get another Condition repeat above etc... If this doesn't give enough options I will think of an alternative "bbjr" wrote: Thanks Ken-hup Apparently your only able to apply one conditional format to a cell. What I'm trying to do is have a cell called day, if that cell value is Monday it's pattern would be Blue, If Cell value = Tuesday then Green, etc.. It's the same cell, just a different value and patern color I want to change based on that value. Thoughts? Bob "ken-hup" wrote: Try Format / Conditional Formatting "bbjr" wrote: Hello, Attempting to auto fill a cell with a color based on a selected word or value in a pick list. example: If selecting Tuesday the Cell would be blue, Monday the Cell would be Yellow, etc.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto fill rows with months based on cell value | Excel Discussion (Misc queries) | |||
| Auto fill from pick list | Excel Worksheet Functions | |||
| How do you fill a cell with a color based on IFTHEN formula? | Excel Worksheet Functions | |||
| How do I change fill color in excel based on data in the cell | Excel Worksheet Functions | |||
| I am trying to color fill a cell based on specific criteria | Excel Discussion (Misc queries) | |||
Linear Mode
