Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula for Single Cell Adress
I've created a roll-up worksheet within a workbook.
Numerical results are posted to C1 using results from B1/A1. If numerical data in C1 is < 65% cell color in D1 turns red If numerical data in C1 is 80% cell color in D1 turns green If numerical data in C1 is 66% but < 79% cell color in D1 turns amber Used conditional formatting and the following formula to create above results. =LOOKUP(B1/A1,{0,"R";0.65,"A";0.8,"G"}) Would like to capture a fourth category in cell C1 (if possible) If the numerical data in C1 has 0 (zero) value. Is their a way to configer the cell color in D1 to turn white? Would like to create a formula that will show the 4 colors in D1 based on the above assumptions. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula for Single Cell Adress
You can have one colour as the base formatting of the cell, and then use 3
conditions in conditional formatting for your 3 other colours. -- David Biddulph "Manyfaces" wrote in message ... I've created a roll-up worksheet within a workbook. Numerical results are posted to C1 using results from B1/A1. If numerical data in C1 is < 65% cell color in D1 turns red If numerical data in C1 is 80% cell color in D1 turns green If numerical data in C1 is 66% but < 79% cell color in D1 turns amber Used conditional formatting and the following formula to create above results. =LOOKUP(B1/A1,{0,"R";0.65,"A";0.8,"G"}) Would like to capture a fourth category in cell C1 (if possible) If the numerical data in C1 has 0 (zero) value. Is their a way to configer the cell color in D1 to turn white? Would like to create a formula that will show the 4 colors in D1 based on the above assumptions. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula for Single Cell Adress
Thanks for describing the solution for the color format. Much appreciated.
Continuing on... How can I add to the current formula a new range that contains the appropriate values for the cell address that returns a 0 value. Thanks... "David Biddulph" wrote: You can have one colour as the base formatting of the cell, and then use 3 conditions in conditional formatting for your 3 other colours. -- David Biddulph "Manyfaces" wrote in message ... I've created a roll-up worksheet within a workbook. Numerical results are posted to C1 using results from B1/A1. If numerical data in C1 is < 65% cell color in D1 turns red If numerical data in C1 is 80% cell color in D1 turns green If numerical data in C1 is 66% but < 79% cell color in D1 turns amber Used conditional formatting and the following formula to create above results. =LOOKUP(B1/A1,{0,"R";0.65,"A";0.8,"G"}) Would like to capture a fourth category in cell C1 (if possible) If the numerical data in C1 has 0 (zero) value. Is their a way to configer the cell color in D1 to turn white? Would like to create a formula that will show the 4 colors in D1 based on the above assumptions. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return cell adress for next non-blank cell in a range | Excel Worksheet Functions | |||
How do I put an adress in a cell in multiple lines?? | Excel Discussion (Misc queries) | |||
SUM using results from an Adress-formula | Excel Discussion (Misc queries) | |||
Is it possible to use a cell adress that is typed in a cell? | Excel Worksheet Functions | |||
Can I create an IF formula for single cell w/ dif. text in Excel? | Excel Discussion (Misc queries) |