ExcelBanter - Change colour of rows in a worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Change colour of rows in a worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/230668-change-colour-rows-worksheet.html)

VJ Sharma[_2_]

Change colour of rows in a worksheet

How can I change each nth row's colour in a worksheet?

FARAZ QURESHI

Change colour of rows in a worksheet

Use Conditional Formatting.

Following formula would set your desired color to the every 7th row .

=mod(row(),7)=0

"VJ Sharma" wrote:

How can I change each nth row's colour in a worksheet?

All times are GMT +1. The time now is 09:51 PM.