Conditional formula based on formatting

[RD]

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

[Marcelo]

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
>
>
>