Prev: Formating cell by Comparing two cells for value
Next: lookup question
From: CBS on 10 Mar 2010 16:34
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.
From: Fred Smith on 10 Mar 2010 18:40
Just the way you specified. Your conditions would be something like:
=a2>a1 [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" <CBS(a)discussions.microsoft.com> wrote in message
news:1FFDC6E0-B496-49BB-A495-FDDB0C450E6E(a)microsoft.com...
> 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.

 | 
Pages: 1
Prev: Formating cell by Comparing two cells for value
Next: lookup question