| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Colours
I have been trying to find an answer to my question for months, but to no
avail. I need to change the colours of cells based on different words I type in. For example "Deployed" = Red Cell, "Awaiting" = Blue Cell etc... Everywhere I look people say use Conditional Formatting, however, this only allows three changes and I have a minimum of 10. From what I can gather I need to program some VB but unfortunately VB may as well be "Klingon". I guess what I am asking is - could anyone provide a quick VB script that could allow me to do what I need? Pleeeeeeeeeeez help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to save one of the MORE COLOURS in the THEME COLOURS? | Excel Discussion (Misc queries) | |||
| Cell Colours | Excel Discussion (Misc queries) | |||
| how do i get more colours for cell shading | Excel Discussion (Misc queries) | |||
| Excel 2003 font colours and cell colours | Excel Discussion (Misc queries) | |||
| How to set different font colours in a cell? | Excel Worksheet Functions | |||
Threaded Mode
