Conditional Formatting
Closed
Dee
-
18 Oct 2011 à 18:49
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 19 Oct 2011 à 17:29
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 19 Oct 2011 à 17:29
Related:
- Conditional Formatting
- Excel clear formatting - Guide
- Excel conditional formatting based on date - Guide
- Excel conditional formatting dates overdue ✓ - Excel Forum
- Conditional formatting if cell contains text - Excel Forum
- Conditional formatting between two values ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
19 Oct 2011 à 06:50
19 Oct 2011 à 06:50
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
19 Oct 2011 à 16:57
19 Oct 2011 à 17:29