View Single Post
  #1   Report Post  
Yong Sheng
 
Posts: n/a
Default 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