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
or add an additional rule, I mean
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
\
[Uploaded an Excel file]
Excelchat Expert
17/07/2018 - 08:16
Please download and check the file.
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
Okay, I already have used not equal sign in the formula I gave you.
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.