Conditional Formating

[Smulzeys]

Hey,

I want to conditionally format a cell so that it goes red whenever the four other cells give the same data value. What should I use.

[Ace_XL]

In CF use

=COUNTIF(A1:A4,A1)=4

wheere A1:A4 are your four other cells

[carrob]

I believe you would need:

=COUNTIF(A$1:A$4,A1)=4

[Smulzeys]

Is not working would you mind showing me ?



Thanks again

Cheers,