Conditional Formatting

[LAURAAB1984]

Hi,

Trying to colour a cell on one sheet if the reference number entered already appears on another sheet.

Googled various options as it keeps filling the cell above instead...

The rule I tried is

=MATCH($A2,'DNA No Support & WD Pre Census'!A:A,0)

Thanks.

 

[RoryA]

That should work as long as you had a cell in row 2 selected when you entered the formula.

 

[LAURAAB1984]

That should work as long as you had a cell in row 2 selected when you entered the formula.

THANK YOU - worked a dream!