how can I use conditional formatting with formula and 3 poss resul

  • Thread starter Thread starter CBS
  • Start date Start date
C

CBS

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.
 
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
 
Back
Top