Conditional Format: IF formula with AND

[tennisbuck]

Hi Board,

On the attached spreadsheet, what would be the formula I can use to conditionally format cell E2 to yellow based on the following criteria:

1.) Cell C2=N
2.) Cell E2 is 305 days or greater then the hire date


Mike

Director	Hire Date	Media Fill Y/N	Date Required	60 Days	Comments
Mike	8/23/2016	N	2/21/2017	6/21/2017

<tbody>
</tbody>

 

[tennisbuck]

It doesn't turn yellow, with this formula =AND(C3=Sheet1!$A$3,B3-TODAY() > = 305).

I have Column E date 7/24/18. This means Hire Date-Todays date is greater then 305 days

 

[tennisbuck]

When I use the formula =AND(C3=Sheet1!$A$3,B3-TODAY() > = 305) it doesn't turn yellow

Column C=NO and I moved the hire date back to 8/13/2014 which -Todays date is greater then 305 days

 

[tennisbuck]

When I use the formula =AND(C3=Sheet1!$A$3,B3-TODAY() > = 305) it doesn't turn yellow

Column C=NO and I moved the hire date back to 8/13/2014 which -Todays date is greater then 305 days

 

[Joe4]

If B3 is a date in the past, flip it around so that it is:

=AND(C3=Sheet1!$A$3,(TODAY()-B3)>=305)

 

[Joe4]

Also, it appears that you have Cross-Posted here: Conditional Formatting using IF/AND

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[tennisbuck]

it Works! Thanks for everybodies help!