Conditional Formating , Proper Formulas?

[cyote101]

hello all, thanks for your help on the last one. I have a new one now. How would i write the following for a conditional Format

if cell value is equal to any of the values in cells a1,a2,a3,a4,a5,d1,d4,d5
Then the format will be applied to the matching cells

Thanks

 

[acw]

Hi

In A1 enter the conditional format, fomula is

=COUNTIF($A$1:$A$5,A1)+COUNTIF($D$4:$D$5,A1)+COUNTIF($D$1,A1)>1

and the format required.

Copy the cell, and paste format to the other cells (A2:A5,d1,D4:D5)


HTh

Tony

 

[Scott Huish]

In acw's formula change the >1 to >0 or drop that part completely.

 

[cyote101]

Thanks Folks. That hit the Spot. YOU ROCK!!!!!!!!!!!!