View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Conditional Formatting

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