Need help don't know if i should use condiontional formatting or macros?

**darkjinni2** · 05-15-2009, 04:56 PM

I would like to have cells fill color depending upon the drop down menu selections.

For example

Cell A1 contains Credit Card Company ex: Visa
Cell A2 contains Amount Paid ex: $45
Cell A3 contains Drop Down Box with Posted and Scheduled

When I selected posted, I want A1 and A2 to fill with the color red and when I selected posted I want them to fill green.

Thank you for the help.
I am very much a beginner when it comes to macros and VBA, but not with general excel experience. Thank you for your help.

**Leith Ross** · 05-15-2009, 05:13 PM

Hello darkjinni2,

Welcome to the Forum!

Based on what you have posted, I don't see any need to use VBA. Conditional formatting will work just fine.

**darkjinni2** · 05-15-2009, 05:16 PM

I need a little more elaboration, I couldn't get conditional formatting to work. Thank you for the help.

**Leith Ross** · 05-15-2009, 05:31 PM

Hello darkjinni2,

1. Select cell "A1"
2. On the main menu select Format > Conditional Formatting...
3. For Condition 1 select Formula Is in the drop down.
4. Type in this formula:=IF(B1="Posted", TRUE, FALSE)
5. Click on the Format... button.
6. Select the Patterns tab of the Format Cells dialog
7. Click on the color you want to use and then click OK. this dialog will close.
8. Click on the Add>> button to bring up Condition 2
9. Follow steps 3 through 7 to set up Condition 2. Change "Posted" to "Scheduled" in step 4.

**darkjinni2** · 05-18-2009, 06:11 PM

Thank you for all your help, one last question. Is there a way to do more than one at once, every time I try it back fills more than what I want.

**mubashir aziz** · 05-19-2009, 02:48 AM

Just make these changes in condition 1 & 2

'=IF($D4="first Pay Period",TRUE,FALSE)
'=IF($D4="First Pay Period",TRUE,FALSE)

Select cells B4:C26 and apply above conditional formatting .....

**DonkeyOte** · 05-19-2009, 02:53 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.