Hi
just to add: This kind of 'formulas' / defined names could crash Excel
prior to version 2003 if you copy these formulas to other sheets

--
Regards
Frank Kabel
Frankfurt, Germany


ivano wrote:
"IMRAN" ha scritto nel messaggio
...
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)

Ciao IMRAN

you can insert a define name as bold
...that refer to:
=GET.CELL(20,INDIRECT("rc[-1]",FALSE))

In worksheet in A1 you have test
In B1 you type: =bold
that return TRUE or FALSE

This formula is not volatile

ivano