Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? 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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi James,
Take a look at Bob Phillips' site http://xldynamic.com/source/xld.Colo...r.html#sorting HTH Martin "J Billy" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting w/ more than 3 conditionas, color code to a different cell | About this forum | |||
How can I change cell color using conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting and Cell Color | Excel Worksheet Functions | |||
Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
Cell color change without using conditional formatting | Excel Discussion (Misc queries) |