Is conditional formatting or formula possible by cell color?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J Billy - 29 Jun 2007 23:06 GMT

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

Signature

J B
IT Professional
DC/VA

Reply to this Message

Rick Rothstein (MVP - VB) - 30 Jun 2007 01:27 GMT

>I was working on a formula in my budget.
>
[quoted text clipped - 14 lines]
>
> 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

Reply to this Message

MartinW - 30 Jun 2007 04:43 GMT

Hi James,

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

HTH
Martin

>I was working on a formula in my budget.
>
[quoted text clipped - 20 lines]
>
> James

Reply to this Message