Templates: Highlighting lines with alternating colors

From Planfix
Jump to: navigation, search

You can apply conditional formatting in document templates and templates for report data export in Excel so that rows are highlighted in alternating colors:

DAJfW0.png

Steps:

  • Open a template in Excel
  • Highlight a row with report data (for data export) or a row that's part of a table (for a document).
  • In the Home tab, click Conditional formatting and select New rule:

xE8Xn5.png

  • In the list Select a rule type select Use a formula to determine which cell to format
  • In the field Format values where this formula is true enter the formula =MOD(ROW(),2)=0

41HbeJ.png

  • Click Format and in the Format cells window open the Fill tab:
  • Select a color and click OK. The color you chose will be shown in the Preview field:

2ZEjXK.png

  • Click OK to save your changes.
  • Save the template and load it to Planfix.


Go To