mubashermukhtar
New Member
- Joined
- Aug 4, 2016
- Messages
- 11
Hello everyone,
Please see the data;
<tbody>
</tbody>
the first column is Installment date while the second is the actual received date. As i have a large data i want some formula that automatically highlighted the installment date which is not been received, In the data, you can see the 28-02-2019 installment is missing, also it should highlight only February installment, not March and April, as it will due after Feb Installment will be received. I have used conditional formatting and used IF condition for the blank cell but the problem is its highlighted all the blank cells but I want to highlight only FEB month and if FEB month installment is received than Mar Installment should be highlighted
Thanks in advance for your help as I always got help in this forum.
Please see the data;
Installment Due Date | Installment Receipt Date |
31-01-2019 | 28-01-2019 |
28-02-2019 | |
30-03-2019 | |
30-04-2018 |
<tbody>
</tbody>
the first column is Installment date while the second is the actual received date. As i have a large data i want some formula that automatically highlighted the installment date which is not been received, In the data, you can see the 28-02-2019 installment is missing, also it should highlight only February installment, not March and April, as it will due after Feb Installment will be received. I have used conditional formatting and used IF condition for the blank cell but the problem is its highlighted all the blank cells but I want to highlight only FEB month and if FEB month installment is received than Mar Installment should be highlighted
Thanks in advance for your help as I always got help in this forum.
Last edited: