Duplicate entries & Conditional Formatting

[hmm]

Is there a formula indicate duplicate data on 2 different worksheets? I
want the font to change to bold.

Thanks.

 

[Jim]

Yes, provided it is a named range within the same workbook.
Select the cells and Format>Conditional Formatting>Formula Is>
=COUNTIF(MyRange,A2)>0

Format for the change if TRUE.

 

[hmm]

Is there a formula indicate duplicate data on 2 different worksheets? I
want the font to change to bold.

Thanks.

I just realized you can't apply cond. formatting to two different
worksheets.

I can't seem to figure out how to enter an IF formula in a cell to compare
data on two worksheets. There must be a way...

 

[hmm]

Thanks! Didn't realize simply naming the range on the other sheet would do
it.

 

[hmm]

Disregard this post. Sorry.

I just realized you can't apply cond. formatting to two different
worksheets.

I can't seem to figure out how to enter an IF formula in a cell to compare
data on two worksheets. There must be a way...