is this what u are looking for ?

suppose B1 is your expiration date -
if the expiration date is 28-dec-2008 so it has 90 dates from today
(i.e., from 28-sep-2008 to 28-dec-2008)
in this case the cell font will be in green and fill should be black ?
if it is more than 90 days or less then 90 days then cell font in
white and fille should be black ?





On Sep 28, 11:46*pm, ajaminb wrote:
I have applied this and it still is not working. *I really appreciate the
assistance because if I can achieve this I will have a tool that will help me
out immensely.

The application is: *I have an Excel spread sheet with a column of
expiration dates. I have the column with a "BLACK" fill and the font is
"White". I need all dates to be white and to turn green 90-days before the
entered date and red once the date has passed. *You helped me with the red
part and it is working well. *If I go back 91 days before the expiration of
the date, it should be white.

I really appreciate this.
--
AjaminB

"muddan madhu" wrote:
try this

condition 2 - | =DATEDIF(TODAY(),B1,"D")=90

On Sep 28, 10:50 pm, ajaminb wrote:
I tested this and it isn't working. How I tested was by putting a date of
12/30/08 in the field. *Today is 9/28/08. *I start ticking of a day at a time
and when I get to 12/27/08 it turns green. *If I go to 6/27/08 it is still
green. *Am I missing something?
--
AjaminB

"ShaneDevenshire" wrote:
Hi,

You want the font to turn green but the fill to be black?

if so,
1. Select the range of dates
2. Choose Format, Conditional Formatting, and in second box choose less than
or equal to and in the third box enter =TODAY()+90
3. Click Format
4. On the Font tab under Color choose Green.

--
Thanks,
Shane Devenshire

"ajaminb" wrote:

The cell *fill color is black and the font is white, if the date show is long
before it expires I want it to remain white, at 90-days before the date
shown, it turns green.

I have tried this and I don't get the desired result as express above:
Select the col B | go to format | conditional formatting | condition 2 -
formula
is =B1(TODAY()-90) | color is picked | and close with, ok

What is happening is the date is turning green if it is before the date shown

--
AjaminB