Question:

How to apply conditional formatting to Excel templates for reports?

Answer:

1. In Excel, highlight the cells where the user wants to apply conditional formatting.  Do not apply to columns or rows, only cells.
   
   
   
   
2. Go to Conditional Formatting under the Home tab.
3. Click New Rule and create a new rule then save.

Related Documentation:

• Microsoft Help Documentation: Using conditional formatting to highlight information