View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
knechm1 knechm1 is offline
external usenet poster
 
Posts: 1
Default Counting data function

Hello,

I am hoping someone can help me out. I have a large spreadsheet which
records various data regarding rejected parts. I want to include a
function/conditional formatting that will count if there is more than one
rejected part number in the last 90 days. There is a date column where the
date of rejection is entered. I would like this "part number" cell to turn a
different color to identify multiple rejections. Can someone help?