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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 15, 2013 at 06:02 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 15, 2013 at 06:02 AM
Related:
- HELP!!! CONDITIONAL FORMATING
- Conditional formating of row based on other cells - Excel Forum
- Conditional formatting based on date ✓ - Excel Forum
- Conditional Formating a word within a sentence - Resent - Excel Forum
- Conditional formatting if another cell contains any text ✓ - Excel Forum
- Conditional formating is applied based on date in two cells ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 15, 2013 at 06:02 AM
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))
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))
