May 18th in Formatting by Excelbud .
Conditonal Formatting – Shading Alternate Rows
This Excel function is very useful when dealing with long lists of data. However, it is extremely easy to use once you know the simple formula.
This Excel function is very useful when dealing with long lists of data. However, it is extremely easy to use once you know the simple formula.
- First, start with a list. Select the complete list by left clicking in cell A2 and holding until cell A19.
- Next, Select ‘Conditional Formatting’ located under the Format dropdown menu. Select “New Rule.”
- From the “New Formatting Rule” box, select “Use a formula to determine which cells to format.” Once selected, enter “=MOD(row(),2) ” into the formula field as shown.
- Next, click the Format button. Select a color and click OK.
- The selected rows should now be formatted in an alternating color pattern. You are now able to insert rows without disturbing the formatting.
good post nice explanation
Wonderful. Excellent!
[...] websites basic web design banner web design bad web design awards web design award winning web design award web design australia web [...]
[...] web design banner web design bad web design awards web design award winning web design award web design australia web design atlanta web [...]
basilikan paris…
[...]8 I am visiting this land for the first time. I have come to know a lot of in qr[...]…