Shaded every second row Please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello from Steved.

I've forgotten how to shade every second row.

Please explain how I can do this.

Thankyou.
 
press control a
then format conditional formating and select formula is and type
=MOD(ROW(),2)=1
click format and then pattern and select the desired color
 
Excellent and thankyou.

N Harkawat said:
press control a
then format conditional formating and select formula is and type
=MOD(ROW(),2)=1
click format and then pattern and select the desired color
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparison of columns using Conditional Formatting 3
EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS 3
Shades of Gray 1
Formula please to highlite every second Row. 3
Alternate Row Shading (Visible Rows Only) 9
Shading rows 2
Shading a cell relative to three other cells & repeat 3
Shading Rows With IF Statements? 5

Back
Top