TWO DATES,150 DAYS APART,NEED ONE DATE TO TURN RED AFTER 150 DAYS
 

I HAVE TWO DATES IN TWO CELLS,150 DAYS APART.HOW CAN I HAVE ONE DATE CHANGE
RED AFTER 150 DAYS ARE UP

TWO DATES,150 DAYS APART,NEED ONE DATE TO TURN RED AFTER 150 DAYS
 

Use conditional formatting , See
http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"440" wrote in message
...
I HAVE TWO DATES IN TWO CELLS,150 DAYS APART.HOW CAN I HAVE ONE DATE
CHANGE
RED AFTER 150 DAYS ARE UP

TWO DATES,150 DAYS APART,NEED ONE DATE TO TURN RED AFTER 150 DAYS
 

you could use conditional formatting. in the example below, the start date
was in F20, the end date in G20: -
go to [Format] - [Conditional Formatting...]

choose 'Formula Is...' rather than 'Cell Value is...' and enter the
following
=G20-F20150

then set whatever formatting you want

that should be it!

hth,

tim

"440" wrote in message
...
I HAVE TWO DATES IN TWO CELLS,150 DAYS APART.HOW CAN I HAVE ONE DATE CHANGE
RED AFTER 150 DAYS ARE UP

TWO DATES,150 DAYS APART,NEED ONE DATE TO TURN RED AFTER 150 DAYS
 

Assume cells A1 and F2. Assume if today is 150 days from A1, then color F2
red.

SelectF2 then do
Formatting = conditional formatting

change cell value is to formula is

put in
=abs(today()-A1)150



select a format

and then "add" your way out.

If that formula doesn't describe the condition you want, write one that does
and consider that one an example.

--
Regards,
Tom Ogilvy




"440" wrote:

I HAVE TWO DATES IN TWO CELLS,150 DAYS APART.HOW CAN I HAVE ONE DATE CHANGE
RED AFTER 150 DAYS ARE UP