D David Johnston Aug 2, 2007 #1 Is there a way to apply conditional formatting if any value in a entire column equals another single cell?? Thanks
Is there a way to apply conditional formatting if any value in a entire column equals another single cell?? Thanks
T T. Valko Aug 2, 2007 #2 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
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
