Excel - How to Change Background Color Based on Cell Value - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

i made a conditional formatting rule for one cell to change color if the value entered is the same as another cell. all cells where the origional cell is 0, the other cell has already changed color. how do I fix it?
Solved by D. B. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 17/07/2018 - 08:05
Welcome to excelchat.
User 17/07/2018 - 08:05
i don't have a lot of time to fix this. I can copy/paste the problem
Excelchat Expert 17/07/2018 - 08:05
Okay, I'm looking forward to it.
User 17/07/2018 - 08:06
as you can see, when the value in column a is 0, the cell in column B changes whether there is a value in it or not
Excelchat Expert 17/07/2018 - 08:06
Yeah, I can see that.
User 17/07/2018 - 08:06
the goal is to have the cell change color if it is is the same as in column A
Excelchat Expert 17/07/2018 - 08:07
May i see the rule you have wrote?
User 17/07/2018 - 08:07
formula where =D5=E5
User 17/07/2018 - 08:07
although in this case it would be A and B
Excelchat Expert 17/07/2018 - 08:08
Okay. Here is the revised formula
User 17/07/2018 - 08:08
also, would there be a way to change the rule for a different color to be put in if B does not equal A?
Excelchat Expert 17/07/2018 - 08:08
=AND(D5=E5,H5<>"")
User 17/07/2018 - 08:08
Excelchat Expert 17/07/2018 - 08:08
Yeah, you can add as many rules you want.
Excelchat Expert 17/07/2018 - 08:09
Please try the formula I gave and let me know.
User 17/07/2018 - 08:09
it did not change anything
User 17/07/2018 - 08:10
so I want it to not change color until a value is added
Excelchat Expert 17/07/2018 - 08:11
Yeah, that would mean do not change color of row 11 and down, right? At the preview window?
User 17/07/2018 - 08:14
correct
Excelchat Expert 17/07/2018 - 08:14
Give me a couple of minutes please.
Excelchat Expert 17/07/2018 - 08:15
\
Excelchat Expert 17/07/2018 - 08:16
Excelchat Expert 17/07/2018 - 08:16
I've applied the same formula I gave you earlier.
User 17/07/2018 - 08:18
this time it worked fine
User 17/07/2018 - 08:18
idk what the problem was
Excelchat Expert 17/07/2018 - 08:18
Sounds good then?
User 17/07/2018 - 08:18
now how do I add a rule, the same, so that it will change red if the answers are not the same
Excelchat Expert 17/07/2018 - 08:20
I'm not supposed to solve more than one problem per session, its against company policy. But I can say that its the same way you have added the first rue.
Excelchat Expert 17/07/2018 - 08:20
rule
User 17/07/2018 - 08:20
thanks, I just was wondering how to type does not equal, instead of equals
Excelchat Expert 17/07/2018 - 08:20
Excelchat Expert 17/07/2018 - 08:20
It is <>
Excelchat Expert 17/07/2018 - 08:21
I hope this helps.
Excelchat Expert 17/07/2018 - 08:23
Anything else?

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.