Conditional Formatting help please.

[serge]

I need help with this Conditional Formatting .I have those formulas that will highlight the 2 same first number in green and the 2 same last numbers in blue but I'm missing a formula that would highlight when 3 same numbers . And also for row 6 a different one that would highlight the 2 numbers no matter what are their position.Thank you very much.

Serge.

Excel Workbook
	A	B	C	D
1	9	27	26
2	3	3	10
3	6	27	27
4	11	11	11
5
6	4	8	4
7
Sheet

 

[serge]

Sorry forgot to put the formulas with Excel Jeanie.

Excel Workbook
	A	B	C	D
1	9	27	26
2	3	3	10
3	6	27	27
4	11	11	11
5
6	4	8	4
7
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Cell Value equal to =$B1	Abc
B1	1. / Cell Value equal to =$C1	Abc
B1	2. / Cell Value equal to =$A1	Abc
C1	1. / Cell Value equal to =$B1	Abc

 

[serge]

Anyone !

 

[villy]

You can try...

In the Formula Is of Cond'l Formatting:

A1: AND(A1=B1,A1=C1)
B1: AND(B1=A1,B1=C1)
C1: AND(C1=B1,A1=C1)

For Row 6:
A1: Or(A1=B1,A1=C1)
B1: Or(B1=A1,B1=C1)
C1: Or(C1=B1,A1=C1)

 

[serge]

Hi Villy, and thanks for responding to the post, I tried your formulas in the cells you mention and I get no result !!?

What I do wrong ?

 

[villy]

Don't put the formulas in a specific cell only it should then be added to your previous cond'l formatting that works it like an additional conditin if certain criterias were met.

Highlight Column A then Conditinal Formatting then in FormulaIs type in the formula(Change to suit your actual range)..
Do same to column B and C it should then work I tried it before posting...

 

[moonfish]

First, remove all your current conditional formatting.

Apply to columns $A:$C
=AND($A1=$B1,$B1=$C1,NOT($A1=""))
Go to Manage Rules and make sure the Stop If True box is checked

Apply to columns $A:$B
=AND($A1=$B1,NOT($A1=""))

Apply to columns $B:$C
=AND($B1=$C1,NOT($B1=""))

Apply to columns $A:$A,$C:$C
=AND($A1=$C1,NOT($A1=""))

 

[serge]

Moonfish,

Your CF works exactly as you described it, Thank you very much for the help.

Serge.

 

[serge]

Thank you also for your help Villy.