ExcelBanter - If cell is Bold then 1, if cell is Italics then 2?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If cell is Bold then 1, if cell is Italics then 2? (https://www.excelbanter.com/excel-discussion-misc-queries/2764-if-cell-bold-then-1-if-cell-italics-then-2-a.html)

Yong Sheng

If cell is Bold then 1, if cell is Italics then 2?

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

All times are GMT +1. The time now is 02:33 PM.