Is conditional formatting or formula possible by cell color?

[J Billy]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[MartinW]

Hi James,

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

HTH
Martin