Can I conditionally format 1 cell to look at 5 cells

  • Thread starter Thread starter DFRESH
  • Start date Start date
D

DFRESH

I am trying to have 1 cell look at 5 cells and change color if any one of the
5 matches the 1 cell
 
Assume the 5 cells are B1:B5, and A1 is the formatted cell:
=COUNTIF(B1:B5,A1)>0
 
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

Conditional Formating based on many cells 5
Excel Highlighting duplicates 0
Excel VBA 1
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Conditional formatting 3
Conditional Formatting assistance 7
Numbers change in cell even when formatted as text 4
Conditional Formatting 1

Back
Top