Question

Plz help

You want Excel to automatically apply “stripes” in an alternating pattern to existing raw data in your spreadsheet. Describe the precise steps you could take to do so. What other function would be added when you apply this change, assuming you have a header row and leave the default options selected?

Answer 1

1)Select the cells you want to shade.

2)On the Home tab of ribbon select Conditional Formatting > New Rule

3)Select 'Use a formula to determine which cells to format' > enter your formula in the 'Edit the Rule Description' field.

4)Click the Format button and from the Format Cells dialog box select the Fill tab > choose your weapon (colour, pattern, fill effect etc.):

Step-by-step explanation: