Formatting Alternating Rows with a Color
Thanks, that worked well.
"Mike H" wrote:
Hi,
Select the rows you want to format in this way then
Format|Conditional Format
Select formula is and enter the formula
=MOD(ROW(),2)=1
Pick your colour
Click OK
Mike
"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.
|