HELP!!! CONDITIONAL FORMATING

[Closed]
Report
Posts
1
Registration date
Thursday February 14, 2013
Status
Member
Last seen
February 14, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have a spreadsheet (d2:d7) with 2012 prices in column D2 and 2013 prices in column D3 for the same product...what i want is if D2 is bigger than D3 format D2 in green and if D3 is lower format D3 in red and copy to the rest of the sheet for the rest of products. Same format color would apply for all higher cost items green and for all lower cost item red.

2012 pricing D2 23.15 item#2366
2013 pricing D3 21.04 item#2366
2012 pricing D4 1.60 item#23677
2013 pricing D5 1.60 item#23677
2012 pricing D6 1.48 item#2355
2013 pricing D7 1.95 item#2355

Thanks

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
what version of excel you are using

This you can use
1. Click on cell D1
2. Select Column D
3. Goto Conditional Format
4. Use this formula for Red
=AND(ROW()>1,IF(MOD(ROW(),2)=0,D2>D3, D2>D1))
5. Use this formula for Green
=AND(ROW()>1,IF(MOD(ROW(),2)=0,D2<D3, D2<D1))