Excel Inserting Alternating Color Row CONDITIONAL FORMATTING - Find India Find

Start inserting coloring row in Excel using CONDITIONAL FORMATTING with support of MOD and ROW function.

• Select the entire data where the alternating color row is to be inserted and copy the MOD formula which is given below.

=MOD(ROW(),2)

• Now go to the home tab - Conditional Formatting - New rule - Use a formula to determine which cells to format - Text Box (Format values where this formula is true) - Paste =MOD(ROW(),2) - Formate - Fill - Choose colour - OK.

6/box-posts/recent