How to Highlight Every other Row or Column in Excel
-Using conditional Formatting-
Select the range (Suppose A1: H100)
Format > Conditional Formatting >Change “Cell Value is” to “Formula is” then enter
=MOD(ROW(), 2)
Click Format,
And choose what ever format you want to apply to every second raw
Click OK, and then Click OK again.
To apply this Columns rather than rows, use
=MOD(Column(), 2)
No comments:
Post a Comment