Conditional Formating

[mubashermukhtar]

Hello everyone,

Please see the data;

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Installment Due Date[/TD]
[TD]Installment Receipt Date[/TD]
[/TR]
[TR]
[TD]31-01-2019[/TD]
[TD]28-01-2019[/TD]
[/TR]
[TR]
[TD]28-02-2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]30-03-2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]30-04-2018[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.