Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I use conditional formatting with formula and 3 poss resul
Want to test 5 calculated results against a static target. If result greater
than target, color cell green. If result = target, color cell yellow. If result less than target, color cell red. Results are presented in a column with the target number in a cell 2 rows above headers in the same column. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I use conditional formatting with formula and 3 poss resul
Just the way you specified. Your conditions would be something like:
=a2a1 [color green] =a2=a1 [color yellow] =a2<a1 [color red] If you need more help, post back with the version of Excel you are using, as the instructions differ. Regard, Fred "CBS" wrote in message ... Want to test 5 calculated results against a static target. If result greater than target, color cell green. If result = target, color cell yellow. If result less than target, color cell red. Results are presented in a column with the target number in a cell 2 rows above headers in the same column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am getting formula displayed in some cells rather than the resul | Excel Worksheet Functions | |||
Custom Header - poss to link to contents of cell? | Excel Discussion (Misc queries) | |||
Is it poss to have a double array in Excel 2003? | Excel Worksheet Functions | |||
Pull cell format across sheets as part of the fomula? Is it poss? | Excel Worksheet Functions | |||
Whether 3 diff fields are blank determines several different resul | Excel Worksheet Functions |