Conditional Format to highlight entrire Row

G

Guest

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.
Shital
 
M

Max

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 ]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top