View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Sumif based on cell format

Not directly. You'd need some VBA procedures.

See this:

http://www.cpearson.com/Excel/colors.aspx

I recommend not doing it this way.

Write a formula based on the logic of *WHY* the numbers are highlighted
green. If they're highlighted using conditional formatting then you should
be able to write a formula based on the conditional formatting logic.

--
Biff
Microsoft Excel MVP


"Fun Dan" wrote in message
...
Is it possible to use Sumif based on the cell's format? For example, I
want
to add up the numbers in a column that are highlighted green.