kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 922
- Office Version
- 365
Hi,
I have the following input table:
I am trying to build a conditional formatting that will only highlight the latest value in column E when the latest date and amount in column C and column D is entered. In the above example, cell E11 is highlighted because the last updated date is 18/10/2022 in column C and there is an amount in column D. As the user enters the next information in column C and column D, the previous cells should no longer be highlighted and the latest cell in column E should highlighted. Is there a formula I could use in conditional formatting to make this work? I appreciate all the help.
I have the following input table:
Book1 | |||||
---|---|---|---|---|---|
C | D | E | |||
4 | Date | Amount | Accumulated Amount | ||
5 | 12/10/2022 | 100 | |||
6 | 13/10/2022 | 100 | 200 | ||
7 | 14/10/2022 | 100 | 200 | ||
8 | 15/10/2022 | 100 | 200 | ||
9 | 16/10/2022 | 100 | 200 | ||
10 | 17/10/2022 | 100 | 200 | ||
11 | 18/10/2022 | 100 | 200 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E6:E11 | E6 | =D6+D5 |
I am trying to build a conditional formatting that will only highlight the latest value in column E when the latest date and amount in column C and column D is entered. In the above example, cell E11 is highlighted because the last updated date is 18/10/2022 in column C and there is an amount in column D. As the user enters the next information in column C and column D, the previous cells should no longer be highlighted and the latest cell in column E should highlighted. Is there a formula I could use in conditional formatting to make this work? I appreciate all the help.