Sunday, January 11, 2015

Shade alternating lines in Excel

Method 2: Use the "Conditional Formatting" option

To use the Conditional Formatting option to shade rows in a worksheet, follow these steps:
  1. Open the worksheet.
  2. Select the cell range that you want to shade, or press Ctrl+A to select the whole worksheet.
  3. Click the Home tab.
  4. In the Styles group, click Conditional Formatting, and then click Manage Rules.
  5. Click New rule.
  6. Click Use a formula to determine which cells to format.
  7. In the Format values where this formula is true box, type =MOD(ROW(),2)=1, and then click Format.
  8. On the Fill tab, click the color that you want to use to shade every other row, and then click OK.
  9. Click OK to close the New Formatting Rule dialog box.
  10. Click Apply, and then click OK to close the Conditional Formatting Rules Manager dialog box.

1 comment:

  1. Though the listed minimums for inside and out of doors bets are doubtless to|prone to} be the identical, they don't mean the same thing. A player betting the $5 minimal on inside bets is allowed to spread 5 $1 chips around on different bets on the within. However, the minimal for out of doors bets means the player must 우리카지노 wager the complete $5 on every exterior bet. Betting $1 on evens, $1 on pink, $1 on the first 12, $1 on the first 18, and $1 on the first column doesn't satisfy the minimal. Knowing which sort of bet to make is necessary for players who want to hodl their very own at the roulette desk. You would think the obvious methodology of choosing the order of numbers on a roulette wheel is to alternate between odd and even, just like with pink and black.