If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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] =a2a1 [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. |
Thread Tools | |
Display Modes | |
|
|