Conditional formatting with multiple formula

[HALL, Steve]

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

 

[Trish]

Hey Steve:

Try this formula in your conditional formatting:
=IF(ISBLANK(K2),(J2-TODAY())<1,"")
The formatting will only show red if this statement is true! So when you
have a date in K2, your fomat will revert to black.
Cheers
Trish

 

[Bob Phillips]

Use

=AND(ISNUMBER(J2),J2-TODAY()<1)

as you formula for the condition you have, it will fail if J2 is blank, so
will not colour

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)