Conditional formating a cell containing a date

A

Amylou

I need to conditional format a cell containing a date based on 3 criteria...
In the example below I need each cell in column J (containing the date) to
turn red with white lettering IF the date in J* is the current date or
earlier AND I* says "CMM" AND L* says neither "accepted" or "rejected".
Based on my criteria cell J2 and J5 should be red with white lettering.

Who Priority date accepted/rejected
CMM 12/22/09
CMM 12/20/09 accepted
CMM 12/19/09 rejected
CMM 12/18/09

NOTE: I already have two of the three allotted conditional formats used with
conditional formats based solely on accepted (gray background/black
font)/rejected(black background/whitee fonat).
 
F

Fred Smith

You want a conditional format like:
=and(I2="CMM",J2<=today(),L2<>"accepted",L2<>"rejected")

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top