MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Expired Date = Red


Posted by greg on October 22, 2001 4:35 AM

I'm tracking on time shipping and need what I think should be a simple formula. Simple if you know what you're doing, that is.

Here's what I'm trying to figure out. I want a cell to highlight itself (say w/ red font) when a date that I've entered expires. Say something is supposed to ship on 10/30/01, on 10/31/01 I want the cell to highlight itself.

Any help is appreciated.


Posted by Aladin Akyurek on October 22, 2001 5:13 AM

Select the cell(s) of interest. I assume your shapping date(s)to start in A2.

Activate Format|Conditional Formatting.
Select Formula Is for Condition 1.
Enter

=A2>=TODAY()

Activate Format.
Select color red on the Patterns tab.
Click OK.
Click OK.

Aladin

===========

Posted by Greg on October 23, 2001 4:16 AM


Works like a charm. Thank you.