View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Detect text styles...

Is this the one you are looking for

cells.Font.Name
cells.Font.ColorIndex (OR .Color)
Cells.Font.Size

If this post helps click Yes
---------------
Jacob Skaria


"emailceloftis" wrote:

Is there a way to detect the styles (CSS type like font-color, font-
weight, color, text-decoration, etc.) applied to the text (not the
cell itself) in an excel cell?

I was hoping to be able to extract a string with embedded/nested span
elements with styles applied to describe the text in a cell... I know
this is probably a pipe dream but there must be a way to extract this
info... can anyone help?

BTW, I will be using VB.NET to automate excel to perform this
function... suggestions?