| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlighting a range using a Macro based on more then 5 conditions
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 P. If P10=CA Then A10:N10 will be highlighted yellow Else If P11=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 | |||
| Counting with conditions based on another range | Excel Worksheet Functions | |||
| shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
| Highlighting Range of Cells based on another cell with 5 condition | Excel Programming | |||
| Add cells from a range based on 2 conditions from 2 other ranges | Excel Worksheet Functions | |||
| Macro to input formula in range based on another range | Excel Programming | |||
Threaded Mode
