Conditional Formatting - IF Statement

I am preparing a spreadsheet for a Job List

- The two important factors here are the invoice date (Column K), and the Pay date (Column L)

- Originally, I needed the entire row to become red if the invoice date was over thirty days old, and the pay date had not been entered.

This was solved by Formula Is = AND(NOW()-$K2>30,$L2="")

However, I now want to have this condition applied to rows that do not contain data yet (other people using spreadsheet need this).

When I copy the formatting to all rows, they all become red, and I would like them to stay white unless data is entered into column K (Invoice date)


I think I need to do this with a single If function for the Formula is part, just do not know how.


Basically ----

If(k2="blank",End Formatting) Else AND(NOW()-$K2>30,$L2="")

It is something like that I would think, but I do not know the logic to type it.



Thanks everyone for your help to get me this far


-todd debacker

That did not work for me.

I attached the file I am testing with. All the rows are formatted with the old method I had. You can kind of see why certain ones are in red or white.
Row 6 has no data and is red, that is what I am trying to fix.



Thanks for the help so far

Thanks,


Your file worked for me now, I guess I wasn't copying and pasting correctly or something.

I actually figured it out doing it a different way.


My Formula Is =IF($K3="",0,AND(NOW()-$K3>30,$L3=""))

They both seem to be the same though.



Thanks for all the help

-todd debacker

Did not know that.


Thanks for the tip though, I'll remember that