Conditional Formatting Question

Hello.

In my spreadsheet, each row is a task that I have to keep track of. How do I conditionally format each row so that if the "Production Date" is >= Today()+90 AND if "Last Action" IS NOT "Transition Approval generated", the row will be colored red?

I know I can do this through Format: Condtional Formatting, and selecting "Formula is"...but I don't know:

A) How to do the AND part of that evaluation
and
B) How to get that to apply to the whole spreadsheet without having to rewrite the formula for each specific row.

Thanks in advance for your help!

Select the entire range you wish to apply the formatting to and in the CF dialog box,

=AND($A2>=TODAY()+90,$B2<>"Transaction approval generated")

A2 is the first cell in my range. Adjust to suit your needs.


HTH
Steve

Didn't work...

I selected my rows, then went to CF and entered the following into Formula is:

=AND($B2>=TODAY()+90,$E2<>"Transition Approval Artifact generated; TStatus to Waiting...")

(That's the correct columns and correct String to check)

Any ideas?

I just tried it again (copied the formula from your post) and it worked no problem. Is the text in your formula exactly as it will appear in E2? If not, it won't recognize it. If there are trailing spaces at the end of your text, it will also not recognize it.

HTH

Steve

Ahh! I found the problem. I actually want TODAY()-90 not +!

Thanks for your help Steve!!! I really appreciate it!

Glad you got it. Thanks for the feedback.

Cheers,

Steve