| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format with VBA - Interior Colour of cell based on value from in-cell dropdown
hi all,
new to VBA - any help greatly appreciated I have searched high and low, possibly not asking the right questions however each cell in my range (D3:AH17) has a Data Validation drop down box. The dropdown is the same in every cell and contains seven values, SL, RL, RDO, TD, PH, SPL, SL (refering to types of leave etc) I need to conditional format the cell (change the interior colour) depending on what the user selects from the dropdown, or leave the interior colour as default if the cell remains empty. I have more than 3 criteria and hence need some VBA code... Im guessing a ThisWorkbook Change event? but im only guessing!! can someone help me out? regards steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format based on existing cell colour ? | Excel Discussion (Misc queries) | |||
| conditional colour fill a row - based on cell value =100% | Excel Worksheet Functions | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
| Conditional Format - Formula to Colour Every 3rd Cell in Offset Range | Excel Discussion (Misc queries) | |||
| Conditional format if cell=0 then font colour same as background . | Excel Discussion (Misc queries) | |||
![Steve[_52_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
