| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting multiple cells if one cells says "X"...
Hi All
I know that I need to write code (VBA) to address this conditional formatting, but I'm a novice and after reading all the postings on conditional formatting I can't work it out - please help... There are 5 conditions and the formatting applies to a growing number of cells (current range is M14:GR603 - but the number of rows will increase). The conditions a If "Retail" is entered in column E of this row, then colour this cell pink If "Brand" is entered in column E of this row, then colour this cell blue If "Special" is entered in column E of this row, then colour this cell yellow If "Generic" is entered in column E of this row, then colour this cell green If "Other" is entered in column E of this row, then don't colour the cell. I am using Excel 2000 (if that makes any difference). Thank for your help BeSmart |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - find cells containg "+" | Excel Discussion (Misc queries) | |||
| Combine text from multiple cells into one cell - =(A1&","&A2","&A3 | Excel Worksheet Functions | |||
| Conditional formatting cells with formulas = "#VALUE!" | Excel Discussion (Misc queries) | |||
| Using conditional formatting to "blank" cells | Excel Discussion (Misc queries) | |||
| Can you "duplicate" "copy" listboxes and code to multiple cells? | Excel Programming | |||
Threaded Mode
