Formatting Alternating Rows with a Color
Thanks!
"Pete_UK" wrote:
Use Conditional Formatting, with a Formula like:
=MOD(ROW(),2)=1
then set the background colour (Patterns tab) to grey.
Hope this helps.
Pete
On Sep 29, 1:18 pm, Daren wrote:
Hello,
Is there a macro or quick way to highlight alternating rows in color? For
example, row 1 would be gray, row 3 would be gray, row 5 would be gray, etc.
Thanks.
|