QAD BI v3 – Tech Level 2 Certification - Part 2 > Troubleshooting Tools > Microsoft Excel for Troubleshooting
  PPT
Microsoft Excel for Troubleshooting
Microsoft Excel for Troubleshooting
 
Different versions of Excel have different options for highlighting results with colors based on the results. Most versions have some type of conditional formatting option, then a choice of how the chosen cell results will get highlighted (we’ll be using the Equal To option). Set the Equal To value to FALSE and pick the color scheme to be displayed when a match to FALSE is found. The path to get to this varies across different versions of Excel, but the principles are the same.