View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Robert H Robert H is offline
external usenet poster
 
Posts: 113
Default Excel 2007 Traffic Light with dates

Herbert, I was able adjust the formula in the indicator cell to match
my needs.
=IF([Exp]Target+7,1,IF([Exp]<Target+1,-1,0))
Its a shame you have to manipulate the sheet so much to make it work.
But whatever it takes...
Thank You very much
Robert

On Nov 20, 3:11*pm, Herbert Seidenberg
wrote:
Excel 2007
Conditional Formatting, Icons
Red traffic light in the middle.http://www.mediafire.com/file/ymqyqz...11_20_09a.xlsx