Conditional Formating

[mubashermukhtar]

Hello everyone,

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.

 

[Marcelo Branco]

Re: Help in Conditional Formating

Maybe...

Assuming your data in columns A:B, headers in row 1

Select A2:B5
In Conditional Formatting try this formula
=AND($A2<>"",$B2="",$B1<>"")
pick the format you want

Hope this helps

M.

 

[mubashermukhtar]

Re: Help in Conditional Formating

Hello,

I tried your formula it not highlighting anything......

 

[mubashermukhtar]

Re: Help in Conditional Formating

Maybe...

Assuming your data in columns A:B, headers in row 1

Select A2:B5
In Conditional Formatting try this formula
=AND($A2<>"",$B2="",$B1<>"")
pick the format you want

Hope this helps

M.

Hello,

I tried your formula it not highlighting anything......

 

[Marcelo Branco]

Re: Help in Conditional Formating

Hello,

I tried your formula it not highlighting anything......

Worked perfectly for me.
Where are your data - columns/rows?

M.