Data Validation & Conditional Formatting
 

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".

Data Validation & Conditional Formatting
 

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

Data Validation & Conditional Formatting
 

Hi,

Set up a table of the Product - Prices, say in D1:E60, and then in column B
use

=VLOOKUP(A1,D$1:E$60,2,FALSE)

If this helps, please click the Yes button

cheers,
Shane Devenshire

"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".