Conditional formatting across entire column

  • Thread starter Thread starter David Johnston
  • Start date Start date
D

David Johnston

Is there a way to apply conditional formatting if any value in a entire
column equals another single cell??
Thanks
 
Conditional formatting across entire column

Do you mean across a row or down a column?

I'll assume you mean across a row

Assume the range of interest is A1:E1
Select the range A1:E1
Goto Format>Conditional Formatting
Formula Is: =MAX(COUNTIF($A1:$E1,$A1:$E1))>1
Click the Format button
Select the style(s) desired
OK out
 
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 an entire row vs. only one cell 1
Conditional format an entire row 1
error in highlighting duplicate values in excel 1
Help needed 0
Conditional Formating 2
Conditional formatting if three conditions are true 1
Excel VBA 1
Conditional formatting - highlight an entire row 1

Back
Top