If B2 is BOLD because of Conditional Formatting, then just replace the "B2
is bold" in your formula with whatever conditions actually make B2
BOLD.........but the BOLD will not carry through to your new result just
using a formula............also, you do not need the "else" in your
formula..........

Vaya con Dios,
Chuck, CABGx3


"Paul" wrote in message
...
Hi,
I want to write a formula along the lines of:

=if( b2 is bold, b2, else "")

Any ideas would be welcome.

PS the Excel is 2002.
Thanks for looking

Paul