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.
- Jun 02, 2023Yes, 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
Patrick2788
Jun 02, 2023Silver Contributor
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
https://support.microsoft.com/en-us/office/apply-color-to-alternate-rows-or-columns-30002ce0-7a1c-4d70-a70c-4b6232f09f5e
MargaretJohnson
Jun 02, 2023Copper Contributor
Thank you for your guidance; it was helpful.