bleitner2008 wrote:
I'm not sure how to do this...
Column A (I've set up a drop down box of values). Column B I want to be
conditional. For example if Column A is "Product A" then populate Column B
automatically with $5.00. If "Product B" then "$10.00".

Not sure this has anything to do with either "Data Validation or Conditional
Formatting".

Maybe this will help:

http://www.contextures.com/xlFunctions02.html