![]() |
|
#1
|
|||
|
|||
![]()
It is already in the code, just read it...Of course, works for 1 cell, as this line says:
If Target.Count > 1 Then Exit Sub If the target cell is cleared, the line of code below, which is already in the code above, will reset the cell color settings. If Len(Target) = 0 Then Target.Interior.ColorIndex = 2: Target.Font.ColorIndex = 1 |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
dice1976 | Word | 4 | 07-24-2012 11:18 AM |
Change cell color everytime a value is selected in dropdown list | angelica_gloria | Excel | 4 | 01-27-2012 06:47 PM |
Made a mistake with a macro change | lance_kidd | Word | 0 | 02-09-2011 06:36 PM |
Ho to perform multi selection in drop down lists? | nashville | Word | 0 | 09-29-2010 07:10 AM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |