Nagaraj Rathinam
New Member
Members
Forum Posts: 2
Member Since:
March 5, 2022
March 5, 2022
Offline
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 |
Jessica Stewart
Northern USA
Member
Members
Trusted Members
Trusted Members
Forum Posts: 219
Member Since:
February 13, 2021
February 13, 2021
Offline
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.
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Kristi Downer, Rick Scott, Katie Campbell, Ryan Tyree
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 287
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Faraz Rafi
Anthony Blake
Jackb57
Ben Tooke
Kelsey Fennell
Jeffree Bunning
Jackie Memije
John Franzon
Darcie Clayton
trevor mir
Forum Stats:
Groups: 3
Forums: 24
Topics: 6873
Posts: 30123
Member Stats:
Guest Posters: 49
Members: 33672
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —