I have created a Quality checking report, which contains a number of Macros and Conditional Formats to highlight cells that return data "Out of Tolerance". Is there a way I can include a further Conditional Format or Macro that will only display the rows on the spreadsheet that contain out of tolerance cells? In essence I only want to display records that need further investigation.