Conditional Formatting
Closed
Dee
-
Oct 18, 2011 at 06:49 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 19, 2011 at 05:29 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 19, 2011 at 05:29 PM
Related:
- Conditional Formatting
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- After formatting computer what's next ✓ - Laptop Forum
- Conditional formatting 3 color scale percentages ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 19, 2011 at 06:50 AM
Oct 19, 2011 at 06:50 AM
1. Select cell A2
2. Do control + A to select all rows
3. Go to conditional format and enter
=OR($F2<>"",$G2<>"") and your green color
4. select cell E2
5. click on E column
6. Go to conditional format. Leave the first conditional format alone ( the one for the green) and add a new format as condition #2
=AND(E2<>"",today()-e2>7) and select red color
2. Do control + A to select all rows
3. Go to conditional format and enter
=OR($F2<>"",$G2<>"") and your green color
4. select cell E2
5. click on E column
6. Go to conditional format. Leave the first conditional format alone ( the one for the green) and add a new format as condition #2
=AND(E2<>"",today()-e2>7) and select red color
Oct 19, 2011 at 04:57 PM
Oct 19, 2011 at 05:29 PM