One cell will turn green when the two other cells match
Solved/Closed
diestra123
Posts
10
Registration date
Monday October 22, 2012
Status
Member
Last seen
July 15, 2013

Feb 17, 2013 at 03:06 AM
diestra123  Feb 20, 2013 at 04:35 AM
diestra123  Feb 20, 2013 at 04:35 AM
Related:
 Conditional formatting if two cells match
 Excel conditional formatting if another cell contains specific text ✓  Excel Forum
 Conditional formatting if another cell contains any text ✓  Excel Forum
 Conditional format based on another cell containing text  Excel Forum
 Excel conditional formatting if cell contains multiple specific text ✓  Excel Forum
 If cell contains text then return value multiple conditions ✓  Excel Forum
7 replies
Kevin@Radstock
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Feb 18, 2013 at 12:54 AM
Feb 18, 2013 at 12:54 AM
@ rizvisa1
That's 2 posts of yours that I have seen which are not helpful. Anyone can write eg: "use Conditional Format for that" or is it that you can not supply the answer!!
@ diestra 123
For your rule, select column A or a range of cells that you wish to apply the rule to > New rule > Use a formula to determine which cells to format.
Then for your rule: =AND($A1<>"",$B1=$C1) apply the formatting you require.
That's 2 posts of yours that I have seen which are not helpful. Anyone can write eg: "use Conditional Format for that" or is it that you can not supply the answer!!
@ diestra 123
For your rule, select column A or a range of cells that you wish to apply the rule to > New rule > Use a formula to determine which cells to format.
Then for your rule: =AND($A1<>"",$B1=$C1) apply the formatting you require.