Conditional formatting based on multiple cells

Question

I'm trying to make a formula for the following, and can't figure out how to get all the conditions in there:

**Column A will be highlighted if:

G# is blank

AND/OR

H is today or before, WHEN J is blank**

to better illustrate, A is the client's name / G is date term's contract was signed / H is date of next contract / J is date contract on H was signed

I'm trying to get the client's name highlighted when the contract is due for signature, so if G is blank it should be highlighted, and if H is due and J is blank it should be highlighted.

And I would like to have this formula in the range A1:A137, with the G,H and J changing accordingly for each row.

Welcome to Stack Overflow. Please take the tour and checkout How to Ask. Then add more details like what did you already tried. — Wicket
– Wicket, Commented Mar 9, 2016 at 16:57
Possible duplicate of Excel Conditional Formatting based on Other Column — Grade 'Eh' Bacon
– Grade 'Eh' Bacon, Commented Mar 9, 2016 at 18:06

Chris Hick · Accepted Answer · 2016-03-09 21:41:30Z

2

Try selecting column A and click Format > Conditional formatting > Custom formula is:

=AND(A1<>"",OR(G1="",(AND(H1<>"",H1<=TODAY(),J1=""))))

Select a background colour and click Done

answered Mar 9, 2016 at 21:41

Chris Hick

3,0961 gold badge15 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Conditional formatting based on multiple cells

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related