Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

Excel: Alternate Row shading using conditional formatting

No comments
Isn't cool if your spreadsheet has alternate row shading?. You can attain this using excel's conditional formatting option and its dynamic. It is easy.


- Select the cell range that you want to apply the formatting
- Then choose Format menu then click Conditional Formatting
- In the conditional formatting dialog box, select Formula Is from the drop-down list, and type this formula:
=MOD(ROW(),2)=0

Alternate Row Shading Using Conditional Formatting
- Click the Format... button and then select the Patterns tab and specify a color for the shaded rows.

conditional formatting in excel

- Click OK button to return to your worksheet.

No comments :

Post a Comment