View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default Conditional formula based on formatting

Hi,

try Chip Person web page
http://www.cpearson.com/excel/CFColors.htm

hth
regards from Brazil
Marcelo

"RD" escreveu:

I want to sum a column of numbers, but if the formatting changes in one of
the cells, i.e.: the cell pattern is changed to yellow, then I want to
exclude that cell from the sum. Any ideas?

Thanks
RD