You can refer to another sheet for CF if you define a name for a cell on
other the sheet.

i.e. defined name "apple" refers to Sheet2A1

On Sheet1 in B2 CFFormula is: =B2=apple

BUT..........you cannot CF the results of a formula based upon just whether
or not the source or part of the source is Bold.

You can only CF on the value of the source cell.


Gord Dibben MS Excel MVP

On Tue, 2 Feb 2010 08:54:01 -0800, zabcikranch
wrote:

I have a VLookup formula to another worksheet, but I need the bold text of
the referenced cells to show up as bold in the formula cell.

I understand you can do that with Conditional formating if the data is in
the same worksheet, but my data is in a different worksheet and it gives me
an error.