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),E720)

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

Is it even possible?

Thanks

James
--
J B
IT Professional
DC/VA

>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),E720)
>
> I tried it but no cigar... am I close at all?

Why can't you use the same condition you used for the conditional format in
your IF statement? If it was sufficient to get the color right, it should be
sufficient to decide if the cell is colored or not.

Rick

Hi James,

Take a look at Bob Phillips' site
http://xldynamic.com/source/xld.Colo...r.html#sorting

HTH
Martin



"J Billy" <(E-Mail Removed)> wrote in message
news:E183960D-D5DA-4287-88F1-(E-Mail Removed)...
>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),E720)
>
> I tried it but no cigar... am I close at all?
>
> Is it even possible?
>
> Thanks
>
> James
> --
> J B
> IT Professional
> DC/VA