Conditional format with IF AND formula

[tscott]

Hello, I've been playing with multiple conditional formats based on formulas and I have one set that I cannot figure out.

I have this conditional format formula to shade a cell orange if the follow is true. B3 and columns J and K are all dates.

=AND(J9-$B$3>=0,J9-$B$3<=15)

It works, except I need to to only format the cell if K9="" and I can't figure out how to add an IF to the above. Can you let me know if this is possible and how?

If K9<>"", I need it to not do any formatting and apply other rules:
=IF(K9<>"",(J9-K9))<0 Red
=IF(K9<>"",(J9-K9))>=0 Green

Thanks for your help!

[daddylonglegs]

You don't need IF, you can add another condition to AND, i.e.

=AND(J9-$B$3>=0,J9-$B$3<=15,K9="")

then for your other two conditions you can use AND again

=AND(K9<>"",K9>J9)

=AND(K9<>"",K9<=J9)

[tscott]

Worked like a charm and that was way too easy. I read earlier about not needing IF, but it didn't sink in. Thank you for taking the time to help!