Quick links

• The Chancellor
• The Provost
• Senior Staff
• Support Units/Staff
• Organizational Structure
• Resources

Mrak Hall
University of California, Davis
One Shields Avenue
Davis, CA 95616
Map

(530) 752-2065
(530) 752-2400 fax

Excel 2003: Row Formatting

Shading Alternate Rows Using Conditional Formatting

1. Select the range you want to format
2. On the Format menu, click Conditional Formatting



3. On the Conditional Formatting window under Condition 1, select Formula Is option. In the data entry box, type =MOD(ROW(),2)=1 Then click the Format button



4. On the Patterns tab of the Format Cells window, select the alternate row shading color and then click OK



5. In the preview section of the Conditional Formatting window, the row shading option you selected you should be displayed. Click OK to complete the process.