| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete row data and cell colour
Sure thing, add one (or both) of these lines:
Range("B1:G1").Interior.ColorIndex = xlNone 'clears background color Range("B1:G1").Font.ColorIndex = 0 'set font color to Automatic Your request seems pretty straight-forward to me. alex1982 wrote: A1 is a drop down menu with 2 choice. when nothing is selected i want to be able to choose the cell colours of B1-G1 myself. as i have a macro to count cells by cell colour. However, when one of these options is selected i want it to delete all the cell info and colours from B1-G1. -- alex1982 ------------------------------------------------------------------------ alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494 View this thread: http://www.excelforum.com/showthread...hreadid=573248 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Cell Colour | Excel Discussion (Misc queries) | |||
| Formatting Data in cell in colour | Excel Discussion (Misc queries) | |||
| can the fill colour of a bar be tied to the data font colour data | Charts and Charting in Excel | |||
| How to enter a colour in a cell & not data ? | Excel Discussion (Misc queries) | |||
| Sorting data by Cell Colour | Excel Programming | |||
Hybrid Mode
