| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlighting Range of Cells based on another cell with 5 condition
Hi, I'm pretty new with VBA. I'm trying to highlight a range of cells for
example (A10:N500) based on cells located in column M. If M10=CA Then A10:N10 will be highlighted yellow Else If M11=GI Then A11:N11 will be highlighted orange and about three more coniditons. I would appreciate a code for this. -Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| highlighting a cell when using a condition formula | Excel Discussion (Misc queries) | |||
| Highlighting rows based on one cell | Excel Worksheet Functions | |||
| Copy range based on condition | Excel Programming | |||
| How to copy only some rows from range based on condition? | Excel Programming | |||
| conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) | |||
Threaded Mode
