View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
StorageHawk StorageHawk is offline
external usenet poster
 
Posts: 2
Default Using font elements as condition criteria

Does anyone know how to use font elements like bold, italic, underline, etc.
as criteria for a formula to return the value from a cell? I am trying to
use bold $ values as the criterion for pulling the $ value into another cell.
I can do the entire column but all I want are the cells with totals and not
the individual component sales figures. This is in a very large spreadsheet
and was already formatted when I received it, so I just wanted to gather the
data I want and pull it into another column. ???? Thanks in advance for any
help.