View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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