i need to make a cell with an expiration date change colors after that date
has passed.
example: I have a cell with 04/11/05 and I need to make that cell font turn
from black to red after that date has passed.
i need to make a cell with an expiration date change colors after that date
has passed.
example: I have a cell with 04/11/05 and I need to make that cell font turn
from black to red after that date has passed.
Have a look at
format>conditional format
--
Don Guillett
SalesAid Software
[email protected]
"jimemma" <[email protected]> wrote in message
news:[email protected]...
> i need to make a cell with an expiration date change colors after that
date
> has passed.
>
> example: I have a cell with 04/11/05 and I need to make that cell font
turn
> from black to red after that date has passed.
Hi
Use CF
See Debra's site for a example
http://www.contextures.com/xlCondFormat01.html
--
Regards Ron de Bruin
http://www.rondebruin.nl
"jimemma" <[email protected]> wrote in message news:[email protected]...
>i need to make a cell with an expiration date change colors after that date
> has passed.
>
> example: I have a cell with 04/11/05 and I need to make that cell font turn
> from black to red after that date has passed.
You can use Format>Conditional Formatting for this.
Click on the cell and CF>Cell Value is: greater than 4/11/2005
Format>Font>Red
Note: the value will change to 38453 from 4/11/2005 if you back in to alter.
Gord Dibben Excel MVP
On Tue, 12 Apr 2005 14:39:58 -0700, "jimemma"
<[email protected]> wrote:
>i need to make a cell with an expiration date change colors after that date
>has passed.
>
>example: I have a cell with 04/11/05 and I need to make that cell font turn
>from black to red after that date has passed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks