Excel Excel Cell colour changing


Joined
Jul 1, 2008
Messages
2
Reaction score
0
How do I pack the following info into an Excel formula?

If A1=1, then cell A6 has a blue background
If A2=1, then cell A6 has a yellow background
If A3=1, then cell A6 has a pink background
If A4=1, then cell A6 has a green background
If A5=1, then cell A6 has a purple background
 
Joined
Nov 6, 2007
Messages
9
Reaction score
0
formula is =IF(A1=1,1,IF(A2=1,2,IF(A3=1,3,0))) and then use conditional formatting (from the format menu) - see attached

Hope this helps.
 

Attachments

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

Top