H
hmm
Is there a formula indicate duplicate data on 2 different worksheets? I
want the font to change to bold.
Thanks.
want the font to change to bold.
Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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.
Select the cells and Format>Conditional Formatting>Formula Is>
=COUNTIF(MyRange,A2)>0
Format for the change if TRUE.
H
hmm
hmm said: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...
H
hmm
Thanks! Didn't realize simply naming the range on the other sheet would do
it.
it.
H
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...