NB!

I'm sure Jason knows this:

This method does not automatically update when changes are
made to the cells formats. Changing a cells format from
BOLD to NORMAL or vice versa doesn't trigger an event so
the formula will not reflect the change until the next
calculation.

Biff

-----Original Message-----
One way, assuming data is in col. A:

1. Press Ctrl+F3.

2. Define the name "istyle" (no quotes) and in
the "Refers
To:" box put:

=IF(GET.CELL(20,!$A1),1,IF(GET.CELL(21,!$A1),2,"") )

3. In cell B1 put:

=istyle

4. Copy the formula down.

5. If you're using XL2002 or earlier, read this:
http://tinyurl.com/3lnld

HTH
Jason
Atlanta, GA


-----Original Message-----
I have a list of hundreds of cells, the cells are either
Bold, Italics, or
Regular.
I want those cells that are bold to result in 1 in
another column. those in
italics to will result in 2.

Am I able to write a "if" function that achieve this? If
not, what should I
do?

Please kindly advise
.

.