Different colour in drop down box? How?

  • Thread starter Thread starter paul thomas
  • Start date Start date
P

paul thomas

Hi All

Have a cell A1 drop down list 1,2 & 3

on cell A2 if 1 then - if 2 then ! if 3 then x

=IF(A1=3,"X",IF(A1=2,"!",IF(A1=1,"-",IF(A1="",""))))

How do i make the background of cell A2 RED if X Orange if ! and
White if -

Cheers

Paul T
 
U¿ytkownik "paul thomas said:
Hi All

Have a cell A1 drop down list 1,2 & 3

on cell A2 if 1 then - if 2 then ! if 3 then x

=IF(A1=3,"X",IF(A1=2,"!",IF(A1=1,"-",IF(A1="",""))))

How do i make the background of cell A2 RED if X Orange if ! and
White if -

Cheers

Paul T
Click to expand...
try conditional formatting
macgru
 
Conditional Formatting.

Look up 'Highlight cells that meet specific conditions' in the Answer
wizard in help
 
Back
Top