Conditional Formatting A Whole Column

V

varsityfresh

In my first column I have a list of supplies that are already in my
possesion. In subsequent columns I have listed other supplies that I need. Is
it possible to have items in the need columns to turn red if it is already
listed somewhere in the first column?
 
S

Sheeloo

Select your data range starting at B1
Choose Conditional Formatting
Choose FORMULA IS
Enter the formula
=COUNTIF($A$1:$A$100,B1)>0

adjust 100 to the last row of your data set

Choose the formatting you want (Red FONT or Fill)

Click Ok
 
Top