Help with IF(NOT(AND)) Conditional Formatting Formula

[itsmekarak]

Hello All,

I'm working on a conditional format formula and have the first part figured out but stuck on the second part.

I need conditional formatting that says, =IF(NOT($B2=0),(AND($C2<B$4,$D2>$C2))) is true then add 1 month to the Due date (column E) and highlight that calculated month.

Therefore, in the attached file, you will see that in row 2 (Item 1), the March cell would highlight as I have manually show above.

And in row 4, (item 3), the April cell would highlight as I have manually show above.

I manually entered the formula into column F just trying to see if I could come up with the conditional formatting solution. I'm just stuck on the last part.

Any help you can give is greatly appreciated.


Thanks, Kara

[AliGW]

Is this the same query as earlier?

[Jonmo1]

Try

=AND($B2<>0,$C2<B$4,$D2>$C2)