Filtering a column from a list

[Jenniferpod]

I have a worksheet that contains 11218 rows. I have a list of 56
values that will appear in Column F that I want to filter out of th
11218 rows. Help

 

[Spencer101]

I want to fill any cell in column f yellow that matches any cell fro
column w.

How's this?

Have a look at the formula used for the conditional formatting

+-------------------------------------------------------------------
|Filename: Jenniferpod Example.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=607
+-------------------------------------------------------------------

 

[Jenniferpod]

How's this?

Have a look at the formula used for the conditional formatting.

Works perfect!! Thank you

+-------------------------------------------------------------------
+-------------------------------------------------------------------