Conditional Formatting A Whole Column

  • Thread starter Thread starter varsityfresh
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

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

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
conditional formatting based on a different cell 2
conditionally format pairs of cells in columns 1
Matching Names 5
SUM - IF - AND 7
***Conditional Formatting Multiple Cells*** 1
conditional formating dates, please help me 1
Excel conditional formatting with Weeknum 4

Back
Top