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

Excel 2010 Conditional Formatting 2
Conditional formatting dates 3
Conditional Formatting to Another Cell 0
Changing cell colors from a function command 3
Conditional Formatting with VBA 4
Conditional Script 2
Conditional Formatting on Index,Match formula 3
Multiple Variables in Conditional Formatting with Excel 2003 1

Top