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

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.
 
F

Fred Smith

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing cell colors from a function command 3
Conditional Formatting on Index,Match formula 3
Conditional Formatting Driving Me Crazy 1
IF OR AND in same conditional formula 2
Conditional Formatting with Percentages - only 2 of 3 working 3
Multiple Variables in Conditional Formatting with Excel 2003 1
Conditional Formatting Formula? 5
Formatting a cell with colour based on whether another cell's valu 1

Top