Conditional formatting across entire column

D

David Johnston

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

T. Valko

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
 
Top