Solved How do I: if X2 = A2, then change X2 to red?

Microsoft Excel 2010 - complete product...
February 8, 2017 at 14:21:51
Specs: Windows 7 Enterprise, Intel(R)Core(TM)i5-6200U CPU@2.30 GHz 2.30 GHz/RAM 4.0 GB
How do I make a cell change color if its value equals that of another cell? Reason: If my "results" # matches my "uploaded" number, I want the "results" # cell to turn red.

message edited by Tulsi17


See More: How do I: if X2 = A2, then change X2 to red?

Report •

✔ Best Answer
February 9, 2017 at 05:39:15
I don't know if this will help because I'm still confused by your mention of Green and Red in Response #2, but here is what I did:

I started with this:

     A     B
1    9     9
2    8     3

I then followed these steps:

1 - Select B1:B2
2 - Open the CF wizard and choose the "New Rule...Use a formula" option
3 - In the "Format values..." field enter =A1=B1
4 - Click the Format button, choose the Fill tab and select Red
5 - Click OK twice

B1 turned Red
When I changed B2 to 8, it turned Red.

Is that what you are looking for?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.



#1
February 8, 2017 at 14:35:23
You will want to use the Conditional Formatting feature of Excel.

Instead of trying to repeat the instructions that can be found via a Google search, I'll offer one random link. If you don't like the way this site explains the feature, there's a large number of other choices available.

http://www.excel-easy.com/data-anal...

If you have any problems, come on back. Good luck!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

#2
February 8, 2017 at 15:21:41
Hi. Thank you for replying! I do understand how to use basic Conditional Formatting such as If A2 > than (fill in the blank), apply a color using the format option. But I don't know how to think about if I want the following:
Targets Uploaded Results
TargetA 9 9
TargetB 8 3

If number in the Uploaded column for Target A (9) = Results for Target A (9), change Results color to green. (Of course this would apply to ALL Targets, in this example Target A and Target B. Target A Results would change to red since Uploaded and Results match. Uploaded (8) and Results (3) for Target B would not change at all since they are different. Thanks again!


message edited by Tulsi17


Report •

#3
February 9, 2017 at 03:39:48
First, a posting tip:

Please click on the blue line at the end of this post and read the instructions on how to format example data so that it is easier for us to read. Then edit/repost your data so that the columns line up correctly. Don't forget to use Column letters and Row numbers as shown in the example.

Second, I'm confused.

In one case it sounds like you want to turn the Results cell Green when they match, and in the other it sounds like you want to turn the Results cell Red. What am I missing?

Finally, if you know how to do CF for ">”, why can't you do CF for "="? Doesn't just changing the operator work for you?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
February 9, 2017 at 05:39:15
✔ Best Answer
I don't know if this will help because I'm still confused by your mention of Green and Red in Response #2, but here is what I did:

I started with this:

     A     B
1    9     9
2    8     3

I then followed these steps:

1 - Select B1:B2
2 - Open the CF wizard and choose the "New Rule...Use a formula" option
3 - In the "Format values..." field enter =A1=B1
4 - Click the Format button, choose the Fill tab and select Red
5 - Click OK twice

B1 turned Red
When I changed B2 to 8, it turned Red.

Is that what you are looking for?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question