Programming Homework Help

Posted on | by Stevepiscles

UBBS Function Excel Spreadsheet

 

I need to create functions for the attached excel as per the following

  1. Status : Find and highlight columns that contain the same number and the Date +/- 2 days Result correct other wise wrong
  2. Size: Find and highlight columns contain the same number and the Date +/- 2 days, and same Size, result is correct, if Size is different Result wrong Size
  3. Agent : Find and highlight columns contain with the same number and the Date +/- 2 days, and same Agent, result is correct , if Agent is different Result wrong Agent

You can use any kind of function!