Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Possible Duplicate:
Formatting a column based on another columns cell TEXT (not value) in Excel

How can I implement the following as an Excel formula?

If column j="renew" or "-" AND the date in column M is 4 days or more behind today's date,
then higlight or change color or whatever in column M.

share|improve this question

marked as duplicate by slhck Oct 3 '12 at 19:23

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

    
It seems you've asked this here already? –  slhck Oct 3 '12 at 19:23

1 Answer 1

You can use this rule:

=AND(OR(J1="renew", J1="-"),TODAY()-M1>4)

I don't know if the setup is the same in Excel 2007, but in Excel 2010, it looks like this: conditional formatting dialog

You can access the dialog through selecting tab Home, menu Conditional formatting, entry New rule....
Then you can choose the format you want (here, a red background), and click OK.

Here's the result:

enter image description here

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.