Forum Discussion
MargaretJohnson
Jun 02, 2023Copper Contributor
Using =MOD(R0W(),2)=0
Is it possible to use the above formula to shade all even rows? If so, please provide guidance. Thank you.
- Yes, with conditional formatting. This article covers the conditional formatting and table methods for accomplishing this task:
https://support.microsoft.com/en-us/office/apply-color-to-alternate-rows-or-columns-30002ce0-7a1c-4d70-a70c-4b6232f09f5e
2 Replies
- Patrick2788Silver ContributorYes, with conditional formatting. This article covers the conditional formatting and table methods for accomplishing this task:
https://support.microsoft.com/en-us/office/apply-color-to-alternate-rows-or-columns-30002ce0-7a1c-4d70-a70c-4b6232f09f5e- MargaretJohnsonCopper ContributorThank you for your guidance; it was helpful.