Try selecting A2:C100, then conditionally format with
Formula is: =COUNTIF($D$1:$D$6,$A2)
[ The "$" sign for $A2 in the formula is important ]
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"****al shah" wrote in message
...
Hi I am Useing conditional formatting to highlight items that are in a
list
on the worksheet with function
=countif($d$1:$d$6,A2)
Where my list is from A2:c100 but when i use this function it highlight
only
that cell how can i highlight row of that data. i.e. a3 to c3

Pls help.
****al