bold text of referenced cell show in formula cell

[zabcikranch]

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.

 

[Gord Dibben]

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 CF>Formula 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