View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mfoster mfoster is offline
external usenet poster
 
Posts: 2
Default Condtional formatting on 2 separate dates

I have a spread sheet that conatins hire dates in one column (A) and
termination dates in a separate column (AU). I want it to highilght the date
in column A if there is a termination date in column AU. Or even highlight
the name of the employee in column F if there is a termination date in column
AU. THANKS!!!