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!


--
sasquatchbill
------------------------------------------------------------------------
sasquatchbill's Profile: http://www.excelforum.com/member.php...o&userid=36550
View this thread: http://www.excelforum.com/showthread...hreadid=568340

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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=568340

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?


--
sasquatchbill
------------------------------------------------------------------------
sasquatchbill's Profile: http://www.excelforum.com/member.php...o&userid=36550
View this thread: http://www.excelforum.com/showthread...hreadid=568340

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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=568340

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

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


--
sasquatchbill
------------------------------------------------------------------------
sasquatchbill's Profile: http://www.excelforum.com/member.php...o&userid=36550
View this thread: http://www.excelforum.com/showthread...hreadid=568340

Glad you got it. Thanks for the feedback.

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=568340