More specific question about adding color code
 

I am trying to do the following without success

1A = company name

1B = renewal date ex 07/19/2007

1Z (hidden) Has current date which updates to current date each time excel
is opened ex 06/20/2007

=IF(1Z-1B120 days) then change cell 1A to yellow

Can someone help me with this.

Thanks in advance

--
Neall

More specific question about adding color code
 

in Conditional formatting:

FormulaIs: =AND(B1<"",($Z$1-B1)120)
set color

OK

"Neall" wrote:

I am trying to do the following without success

1A = company name

1B = renewal date ex 07/19/2007

1Z (hidden) Has current date which updates to current date each time excel
is opened ex 06/20/2007

=IF(1Z-1B120 days) then change cell 1A to yellow

Can someone help me with this.

Thanks in advance

--
Neall

More specific question about adding color code
 

i hope i can help by giving sample to answer briefly your specific question.

example: Pedro wants to know when the fruit will be ripe by having cell A1
to remain on green then turns yellow when the specified time difference has
been reached.

go to cell A1, click menu FormatConditional formattingcondition 1use
"formula is, type (without quotes)
either "=(z1-b1)120"
or Maybe "=(today()-b1)120"
then choose the formatfont/border/pattern to show the Yellow....

regards,
driller
--
*****
birds of the same feather flock together..



"Neall" wrote:

I am trying to do the following without success

1A = company name

1B = renewal date ex 07/19/2007

1Z (hidden) Has current date which updates to current date each time excel
is opened ex 06/20/2007

=IF(1Z-1B120 days) then change cell 1A to yellow

Can someone help me with this.

Thanks in advance

--
Neall

More specific question about adding color code
 

or the same also in another form like
FormulaIs: =(B1<"")*($Z$1-B1)120
--
*****
birds of the same feather flock together..



"Toppers" wrote:

in Conditional formatting:

FormulaIs: =AND(B1<"",($Z$1-B1)120)
set color

OK

"Neall" wrote:

I am trying to do the following without success

1A = company name

1B = renewal date ex 07/19/2007

1Z (hidden) Has current date which updates to current date each time excel
is opened ex 06/20/2007

=IF(1Z-1B120 days) then change cell 1A to yellow

Can someone help me with this.

Thanks in advance

--
Neall