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