Revealing Cell Format Information

[Dr Zayas]

Hello all,

I was wondering if there is a function that will reveal certain formatting attributes of a cell like whether the text is Bold or Underlined and other stuff like that.

I cannot seem to find one despite searching the threads and looking in MS Excel Help.


Thanks!

[VBA Noob]

Try a VBA function. Press Alt + F11 > insert > module and paste in the below

To call it enter the formula with your cell ref

=CellFormat(A1)

Please Login or Register  to view this content.

VBA Noob