If Statements and Conditional Formatting

[jtothej]

Trying to highlight an entire row using conditional formatting.

If cell g2 = "2-Qualified" and cell n2 <= today's date + 180, then use no color for the fill.

If cell g2 does not equal "2-Qualified" and cell n2 <= today's date + 180, then fill row with green.

I have previously used the following conditional formatting for the date values of column n2 to incorporate the date issue and highlight the entire row: =$N2<=TODAY()+180

However, I now have to incorporate a value of another cell into the equation and I am not sure how to do this. Thanks in advance for any help...

 

[Jonmo1]

Welcome to the board.

Try

=AND($N2<=TODAY()+180,$G2<>"2-Qualified")

 

[jtothej]

That works great...

Thanks for the quick response...

 

[Jonmo1]

You're welcome.

 

[jtothej]

Now I am running into another issue because I have 3 conditional formats based on the AND formula. So I need to use a range for the date value.

For example:
The resolution you gave me of =AND($N2<=TODAY()+180,$G2<>"2-Qualified") work for all days from today up to 180 days out.
I need this to use a date range and only work if it is 91 - 180 days out.

Any thoughts?

 

[Jonmo1]

Try
=AND($N2<=TODAY()+180,$N2>=TODAY()+91,$G2<>"2-Qualified")

 

[jtothej]

Nice, this works. Thanks again.