T

#### TheMTCGal

I need to set up conditional formatting with 3 conditions and each condition

is to look at 3 different cells in a row and determine if they meet the

condition. Currently what I have setup does not limit the conditions to have

all 3 in the same row...it will indicate that I have met the condition when

in fact one of the values is only true if you look in different rows (see

example).

Here is what I have setup so far:

condition 1 -

AND((COUNTIF($E$19:$E$10000,$E19)>1),(COUNTIF($A$19:$A$10000,$A19)>1),(COUNTIF($F$19:$F$10000,$F19)>1))

condition 2 -

AND((COUNTIF($E$19:$E$10000,$E19)=1),(COUNTIF($A$19:$A$10000,$A19)>1),(COUNTIF($F$19:$F$10000,$F19)>1))

condtion 3 -

=AND((COUNTIF($E$19:$E$10000,$E29)>1),(COUNTIF($A$19:$A$10000,$A29)=1),(COUNTIF($F$19:$F$10000,$F29)=1))

and example of the data is as follows:

column a column b column c column d column e column f

row 18 "Unit " "Desc" "Type" "Status" "WO" "WO Desc"

row 19 1004M1 SWIVEL S 15 605161 REPLACE SEAL FOR COUPLING

row 20 1004M1 SWIVEL S 15 605161 REPLACE SEAL FOR COUPLING

row 21 1005M3 SL1 ROLL P 40 607696 Drive Service - Shutdown

row 22 1006 HEAD 1 S 15 582290 replace skirting

row 23 1006 HEAD 1 P 40 600453 FRMING HEAD INSPCTION

row 24 1006 HEAD 1 P 40 608227 FRMING HEAD INSPCTION

row 25 1006M12 ROLL 2 S 10 607840 Change rosta.

row 26 1007 CONV S 40 398889 INSTALL GREASE LINES ON SCREWS

row 27 1007 CONV P 40 605779 Swivel Trough Mechanical Insp

row 28 1008 BIN 4 S 40 441259 CHANGE DECK

row 29 1008M3 PICKER P 40 594158 Drive Service - Shutdown

row 30 1008M3 PICKER P 40 603352 Pick Rolls Insp - Operating

row 31 1008M3 PICKER P 40 605910 PICK ROLL DRIVE OPER-INSP

I set up the conditional formatting on column E. Cell E29 is meeting

condition 2 when it shouldn't because the 3 criteria cannot all be found in

Row 29...

Please help