Excel Excel Cell colour changing

[GaryAus]

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

 

[shazbat99]

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.

 

[GaryAus]

Thank you

Thanks Shazbat99!