Question description:
This user has given permission to use the problem statement for this
blog.
I have a question about Conditional Formatting.
=IF('Sheet1'!A1="X",IF('Sheet1'!B1="Y", TRUE, FALSE),FALSE) the set the cell background to red.
I would like to make it so that if Sheet1'!B1="Z" I set the back to blue.
How can I achieve this.
Solved by B. F. in 39 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
10/05/2018 - 03:35
Hello, welcome to Got It Pro.
User
10/05/2018 - 03:35
Hi
Excelchat Expert
10/05/2018 - 03:36
I've seen your problem. Could you please take a look at the Excel Online panel on the middle.
User
10/05/2018 - 03:37
Yes
User
10/05/2018 - 03:39
Looking
Excelchat Expert
10/05/2018 - 03:39
Just a few moments.
User
10/05/2018 - 03:39
Okay, thanks
Excelchat Expert
10/05/2018 - 03:43
Okay, let me show you a more efficient way to do what you are trying to achieve.
Excelchat Expert
10/05/2018 - 03:43
But for that I would need to know which version of Excel you are using.
User
10/05/2018 - 03:44
Excel 2010
Excelchat Expert
10/05/2018 - 03:44
Okay
Excelchat Expert
10/05/2018 - 03:48
Does this work for you?
User
10/05/2018 - 03:49
I don't see anything
Excelchat Expert
10/05/2018 - 03:49
Why that is strange. Just a minute.
Excelchat Expert
10/05/2018 - 03:50
Dont you see the red backgrounds?
User
10/05/2018 - 03:50
No, the sheet is unchanged
User
10/05/2018 - 03:51
Is Chrome an acceptable browser for this?
Excelchat Expert
10/05/2018 - 03:51
Yes, it works on all browsers.
Excelchat Expert
10/05/2018 - 03:51
Could you please try it on your computer as I guide you through the way?
User
10/05/2018 - 03:51
Sure
Excelchat Expert
10/05/2018 - 03:52
Okay
Excelchat Expert
10/05/2018 - 03:52
Can you the my table on the Excel Online panel?
Excelchat Expert
10/05/2018 - 03:53
*Can you see
Excelchat Expert
10/05/2018 - 03:53
Could you copy and paste it to Excel on your computer?
User
10/05/2018 - 03:54
ok,
User
10/05/2018 - 03:56
I saved your table and opened it locally
User
10/05/2018 - 03:56
ee the letters in the cells, but no color formatting
Excelchat Expert
10/05/2018 - 03:56
Okay. Now select A2 to A5 and then Home> Conditional Formatting>New Rule
Excelchat Expert
10/05/2018 - 03:56
A1 : A5
User
10/05/2018 - 03:57
done
Excelchat Expert
10/05/2018 - 03:57
Okay now in the new formatting rule box, select "use formula to determine which cells to format"
User
10/05/2018 - 03:58
done
Excelchat Expert
10/05/2018 - 03:59
Now in the format values where this formula is true type : AND(A1="X",B1="Y")
Excelchat Expert
10/05/2018 - 03:59
you need an equal(=) sign in front of the formula.
User
10/05/2018 - 04:00
okay, so =AND(A1="X",B1="Y")
Excelchat Expert
10/05/2018 - 04:00
Yes!!
Excelchat Expert
10/05/2018 - 04:01
Now click format, go to the fill panel, select the background color to red.
User
10/05/2018 - 04:01
So how would I change it to make A1 shade blue if B1="Z" ?
Excelchat Expert
10/05/2018 - 04:01
You just repeat the same process.
User
10/05/2018 - 04:02
Put both rules on the same cell?
Excelchat Expert
10/05/2018 - 04:02
yes.
Excelchat Expert
10/05/2018 - 04:02
I'm sorry I said something wrong earlier.
User
10/05/2018 - 04:03
Ahh, I got it. seems to be working
Excelchat Expert
10/05/2018 - 04:03
Before assigning the rules, you need to select A1:B5
Excelchat Expert
10/05/2018 - 04:03
Does that solve your question?
Excelchat Expert
10/05/2018 - 04:07
Thanks for using Got It Pro.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.