Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
182
Views
Topic starter
Need to highlight when the actual closeout date is exceeding the target period
| Issue Date | Target period in days |
|
Actual closeout Date | Overdue Days | |
| 5-Aug-20 | 30 | 4-Sep-20 | 23-Sep-20 | -49 | |
| 6-Aug-20 | 30 | 5-Sep-20 | 13-Oct-20 | -68 | |
| 7-Aug-20 | 30 | 6-Sep-20 | 4-Nov-20 | -89 | |
| 14-Jul-20 | 30 | 13-Aug-20 | 10-Sep-20 | -58 | |
| 15-Jul-20 | 30 | 14-Aug-20 | 29-Sep-20 | -76 | |
| 10-Nov-21 | 90 | 8-Feb-22 | 25-Feb-22 | -107 | |
| 2-Dec-21 | 90 | 2-Mar-22 | 20-Mar-22 | -108 | |
| 15-Dec-21 | 90 | 15-Mar-22 | 28-Mar-22 | -103 | |
| 15-Dec-21 | 90 | 15-Mar-22 | 10-Apr-22 | -116 | |
| 15-Dec-21 | 90 | 15-Mar-22 | 18-Mar-22 | -93 | |
| 10-Jan-22 | 90 | 10-Apr-22 | 15-Apr-22 | -95 | |
| 11-Jan-22 | 90 | 11-Apr-22 | 5-May-22 | -114 | |
| 17-Jan-22 | 90 | 17-Apr-22 | 21-Apr-22 | -94 | |
| 17-Jan-22 | 90 | 17-Apr-22 | 24-Apr-22 | -97 |
Posted : 06/04/2022 2:52 am
You just need a Conditional Formatting Rule. With the cells you want the rule applied to<Home Tab<Styles<Conditional Formatting<New Rule<Use a formula to determine which cells to format<in the formula bar insert this formula =$D4>$C4 click on the Format button and choose how you want those cells formatted. Boom, you win.
Posted : 06/04/2022 10:23 am
