View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Russell Russell is offline
external usenet poster
 
Posts: 31
Default conditional formatting

I want to be able to search for two things in a column. The first is a value
of less than or greater than $100. (OK so that is really two things I guess).
The second is to be able to see if that amount is within the previous 365
days. There is another column for the date. I can get part to work but am
having trouble with the date. Any ideas would be greatly appreciated.