P
Patch
Hi there, please help with the following...
Working with two sheets, I have a list of alpha numeric referances in col.
A. I would like the cells in col. A on sheet 1 to show up as a differant
colour if they appear appear in list in col A on sheet 2.
What formula should I use in the conditional formatting?
Many Thanks.
Working with two sheets, I have a list of alpha numeric referances in col.
A. I would like the cells in col. A on sheet 1 to show up as a differant
colour if they appear appear in list in col A on sheet 2.
What formula should I use in the conditional formatting?
Many Thanks.