highlight cell

M

MAX

I so this post below which I'm going to use in the future and it works
perfectly but I can't do the cell highlighted. I am using Excel 2007.
Thankyou.


(Need help with a formula that will Count down the number of days before a
contract will expire. When the date is Expired, I need it to say "EXPIRED",
and highlight the cell. Can anyone help me with this?)
 
O

Otto Moehrbach

Use the formula:
=IF(TODAY()>B2,"EXPIRED","")

in that cell. I assumed B2 has the expiration date. Change that as needed.
Then use Conditional Formatting in that cell. The condition is that the
cell is equal to EXPIRED. Set the cell color as desired. HTH Otto
 

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

Similar Threads

Excel Formula Help 7
Conditional formatting dates 3
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Macro Loop 0
Create a dynamic list 3
Conditional Formatting 4
Conditional Formatting Less Than Today Week Days only 0
Conditional formatting with dates 7

Top