Conditional formating help needed

  • Thread starter Thread starter PCOR
  • Start date Start date
P

PCOR

1 1000
2 1500
3 900
4 2000
5 2000
6 4000

Given the data above in COL A
Starting at line 2 I want to color the background of the cell containing
"1500" in GREEN because it is HIGHER than the one above it
Line 3 "900" would be color RED because it is lower than the one above
Line 5 "2000" would be YELLOW because it is the same size as the the one
above

How can this be done in Conditional formatting.
Thanks
 
Highlight A3:A7

Formula is =A3>A2 (Green)
Formula is =A3<A2 (Red)
Formula is =A3=A2 (Yellow)
 
You must log in or register to reply here.

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

Conditional formatting dates 3
[ask] Quartile and Frequency 0
data series color - conditional formatting 2
listing unmatched items! 7
If Condition 4
how can I use conditional formatting with formula and 3 poss resul 1
Using the Icon Set for Conditional Formatting 1
Connect different worksheets 2

Back
Top