Previous Topic Next Topic

HELP!!! CONDITIONAL FORMATING

Closed
valencc7 Posts 1 Registration date Thursday February 14, 2013 Status Member Last seen February 14, 2013 - Feb 14, 2013 at 09:55 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 15, 2013 at 06:02 AM
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

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 15, 2013 at 06:02 AM
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))
0