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.