lifeonathread
New Member
- Joined
- Oct 5, 2010
- Messages
- 12
Ok... you all are probably going to think I'm crazy....
What I'm trying to do is set up a nested IF, NOT, AND statement with conditional cell formatting. I already used the Menu cell formatting for a different purpose and because I can't put in more than three conditions, I need to manually put in the conditional formatting with a formula.
In Layman's terms I'm trying to make it say the following:
IF Cell A1 does NOT equal "No" AND the DATEDIF between A2 and TODAY > 30 days, then Color row A blue.
This is what I have for the formula so far:
=IF(W2=(NOT(W2="No"))AND((DATEDIF (R2, TODAY)>30)),=COLOR A2:AZ2=(155,10,0))
What I'm trying to do is set up a nested IF, NOT, AND statement with conditional cell formatting. I already used the Menu cell formatting for a different purpose and because I can't put in more than three conditions, I need to manually put in the conditional formatting with a formula.
In Layman's terms I'm trying to make it say the following:
IF Cell A1 does NOT equal "No" AND the DATEDIF between A2 and TODAY > 30 days, then Color row A blue.
This is what I have for the formula so far:
=IF(W2=(NOT(W2="No"))AND((DATEDIF (R2, TODAY)>30)),=COLOR A2:AZ2=(155,10,0))
