Need help with a Conditional Formatting/If...and formula!!!!

[cmcdermott]

I am looking to format an entire row based off two Logical Tests.

Let's say my spread is A4:P4

I want to format the entire row to show red text IF N4 is blank AND (today's date-A4 [which will be a date format] > 15)

I hope someone can help me figure out how to write this formula!! Thank you.

[Tony Valko]

Select the range A4:P4

Conditional Formatting
Use the "Use a formula..." option

Formula: =AND($N4="",TODAY()-$A4>15)

[6StringJazzer]

Highlight A4:P4. In conditional formatting choose "Use a formula..." and use this formula.

Please Login or Register  to view this content.

Edit: Should have included those $ as shown in Tony's solution.

[cmcdermott]

Thanks! I think I had the right idea in mind, I just was unsure of the syntax.

[Tony Valko]

You're welcome. Thanks for the feedback!

[cmcdermott]

Hey! I'm coming back for help on the same formula from September.

That formula had been based off two logical tests. Now, on the same spreadsheet, I want to add an additional conditional formatting formula two cells over.

Let's assume the same instance as before.

This time, I want P4 to show blue text IF P4 is blank AND (today's date-N4 [which will be a date format] > 15) AND N4 is NOT BLANK

Let me know if you can help with the proper syntax

[cmcdermott]

Thank you to you all for the help - the problem you helped me solve is still in use in a spreadsheet i use at work to track some stuff. Made that task so much easier of these last couple years!