| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlight cell
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?) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
highlight cell
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 "MAX" wrote in message ... 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?) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I auto highlight a cell with the same data as another cell | Excel Worksheet Functions | |||
| how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
| Highlight Cell Based Upon Referenced Cell Data | Excel Worksheet Functions | |||
| click on one cell to find and highlight a related cell? | Excel Discussion (Misc queries) | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
Linear Mode
