Conditional Formatting Question

[sasquatchbill]

Hello.

In my spreadsheet, each row is a task that I have to keep track of. Ho
do I conditionally format each row so that if the "Production Date" i

= Today()+90 AND if "Last Action" IS NOT "Transition Approva

generated", the row will be colored red?

I know I can do this through Format: Condtional Formatting, an
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 t
rewrite the formula for each specific row.

Thanks in advance for your help

 

[SteveG]

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

 

[sasquatchbill]

Didn't work...

I selected my rows, then went to CF and entered the following int
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

 

[SteveG]

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

 

[sasquatchbill]

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

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

 

[SteveG]

Glad you got it. Thanks for the feedback.

Cheers,

Steve