Excel Excel Cell colour changing

G

GaryAus

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
 
S

shazbat99

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

  • z.jpg
    z.jpg
    50.7 KB · Views: 178

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

Last Modified By in a cell by user 3
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel display two dates in one cell - excel 2010 2
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
VBA Linest function for polynomial regression on horizontal range 0
Blank Cells 3
Excel How to change cell colour in Excel based on number *or* letter?!? 3
How to delete ALL cells containing the same data 1

Top