Conditional Formatting A Whole Column
 

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?

Conditional Formatting A Whole Column
 

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



"varsityfresh" wrote:

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?