Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

change cell colors without conditional formatting

0

if i select  the word "plywood" from the A1 drop down list i want A2 thru A5 to turn red.

if i select  the word "plastic" from the A1 drop down list i want A2 thru A5 to turn blue.

please help.

Thank you, Roy

Answer
Discuss

Discussion

Is there a reason why you don't (or can't) use conditional formatting? Seems to be the easiest way to do it rather than via VBA.
Cathy (rep: 53) Mar 11, '19 at 9:34 am
Add to Discussion

Answers

0

On the Ribbon; Home use the paint can. it has a downward pointing triangle, from there select the color that suits you.

Discuss

Discussion

thank you, but what i want is the color to change based on the dropdown selection. If i select plywood from the drop down i want cells  A2 and A3 to turn blue, if i choose plastic from the dropdown i want cells B3 and B4 to turn green.
Roy Shimp (rep: 2) Mar 11, '19 at 9:14 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login