![]() Highlight the area you want to apply the effect to. It’s sleek, professional-looking, and a breeze to do with Excel’s built-in tools. Step 6: In the Format Cells dialog box, select one background color, and click OK button to save settings. See the following screenshot: Step 5: After clicking the Format button in the New Formatting Rule dialog box, it displays Format Cells dialog box. Step 4: Enter =MOD(COLUMN(),2) in the Format values where this formula is true: box. Step 3: In New Formatting Rule dialog box, Select the Use a formula to determine which cells to format item in the Select a Rule Type section. ![]() ![]() Step 2: After clicking the Home > Conditional Formatting > New rules, it shows the New Formatting Rule dialog box. Step 1: Select the range in which you will shade every other column. Using Conditional Formatting command can shade every other row or column in a selection of Microsoft Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |