Hi all,

I have a simple spreadsheet with an invoice created column (H2), then
J2 is created with a formula for 30 days after (H2) date. With
conditional formatting i have made (H2) change to red when invoice is
overdue using formula =(J2-TODAY())<1. What i need to know is how to
make J2 change back to black when a date is entered into (K2) (invoice
paid) column

any help would be much appreciated, Thanks,

Steve