I was working on a formula in my budget.

Right now, all deductions and deposits are entered in the same column
(column B). With the current balance in the account in column c.

I differentiate between what I spend the money on by highlighting the cell
in column b a specific color or shade.

What I want to do in column E is keep track of money spent per color. Just
one color specifically (gray-25% - index 15).

Is it possible to have a conditional format in an IF formula?

I was thinking something like:

IF(B721=(interior.colorindex=15),SUM(E720+B721),E7 20)

I tried it but no cigar... am I close at all?

Is it even possible?

Thanks

James
--
J B
IT Professional
DC/VA