View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default if- then statements

you can't do this with a formula. you have to do it with conditional
formatting.
select cell B2 & choose Format, Conditional
select "Formula Is" from the 1st dropdown box.
in the formula row, type:
=A1=23
then choose your formatting.
hope that helps
:)
susan


On Feb 20, 1:58*pm, Paul wrote:
hi there. i cant figure out how to do an "if - then" type of function. If A1=
23 *then B2= Red
or,
if A1= Blue then B1= Color

wheere i have a list of datat that can be chosen for A1 and then a
corresponding list of data for B2. the B2 cell will be automatically
populated once i fill in A1.

am i asking this right? does anyone know or have a moment to help? thanks!!!!