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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation and drop-down list using IF, AND and what else? 8
Drop-down list and error message 1
Turning on data validation in one cell based on the contents ofanother cell 1
VBA code, value in a range 3
If formula and Data Validation parallely 1
Scrabble Value calculation for Welsh words 0
Conditional formatting 4
Dynamic Validation List 1

Back
Top