Thread: Flagging a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
oscar oscar is offline
external usenet poster
 
Posts: 55
Default Flagging a cell

Hi,

I have two cells that I would like to use to flag one. I have a cell that
would show if an appraisal was done inside a home or outside. My Cell title
is "Apprsl I or E" and I have a list of properties that have an appraisal of
I or E. The column next to it is the appraisal date. I would like to flag the
appraisal date column cells if appraisal I is older than 6 months from
todays date and if appraisal E is older than 9 months from todays date.

Thanks