Change cell color when selection is made from a drop down list

		Microsoft Office Forums > Microsoft Excel > Excel
Change cell color when selection is made from a drop down list

FAQ

Thread Tools

Display Modes

#10

08-27-2012, 10:49 PM

Catalin.B

Windows Vista Change cell color when selection is made from a drop down list

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Insert this line of code under line: For Cell= 3 to 350

Code:

If Len(ActiveSheet.Cells(Cell, "D")) = 0 Then ActiveSheet.Cells(Cell, "D").Interior.ColorIndex = 2: ActiveSheet.Cells(Cell, "D").Font.ColorIndex = 1

Tip: When you press the close button to run the code and save the workbook, after the code runs, you may choose from the save dialog to cancel closing, so the code runs but the workbook is still open...

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro ? - Checkbox in Word + drop down selection help	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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:28 AM.