If Statements and Conditional Formatting

jtothej

New Member
Joined
Jan 6, 2014
Messages
9
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...
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Welcome to the board.

Try

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

jtothej

New Member
Joined
Jan 6, 2014
Messages
9

ADVERTISEMENT

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

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Try
=AND($N2<=TODAY()+180,$N2>=TODAY()+91,$G2<>"2-Qualified")
 

Forum statistics

Threads
1,141,058
Messages
5,704,031
Members
421,323
Latest member
Exidous

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top