You can use this VBA function:

Function isbold(a As Range) As Boolean
Application.Volatile
isbold = a.Font.Bold
End Function

There is a problem: Changing the font is not changing the value, so Excel
thinks it is not necessary to recalc the function. You'll have to force a
recalc with F9.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"IMRAN" wrote in message
...
Hey

I need the formula which tell me that any specific cell contains the text
that text is bold or not, and, italic or not.

is there any formula to check it =ISBOLD(A1)