bold text of referenced cell show in formula cell


Z

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.
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top