Hello!

If you could help, I'd truely appreciate it.
A B C D E F
1 P P P
2
3
4

I want to Conditionally Format all cells that if there is an apprearance of "P" more than twice in Row 1, it will turn the cells yellow.

Please Help.
Thank You in Advance
CdotWin

Hi CDotWin,

Assuming you want to do this in VBA, try:

Sub Tester()
Dim Rng As Range

Set Rng = Range("A1:D10") '<<<<<<<<<<<<<<<< CHANGE!
With Rng
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, _
Formula1:="=COUNTIF($1:$1,""=p"")2"
.FormatConditions(1).Interior.ColorIndex = 19
End With
End Sub

Change the range to suit your requirements.


If you want to do this manually, try:

Select the cells that you want potentially highlighted.,
Format | Conditional Formatting... | Condition1 | Formula Is |
=COUNTIF($1:$1,"=P")3 | Format ... | Patterns ! Select your color | OK


---
Regards,
Norman


"CDotWin" wrote in message
...
Hello!

If you could help, I'd truely appreciate it.
A B C D E F
1 P P P
2
3
4

I want to Conditionally Format all cells that if there is an apprearance
of "P" more than twice in Row 1, it will turn the cells yellow.

Please Help.
Thank You in Advance
CdotWin