alternating row colors

Hi,

Click a column hedare letter then drag to select as many columns as you want this to apply to then:-

Home tab | Conditional formatting | New rule | Use a formula to decide which cells to format and enter this formula

=MOD(ROW(),2)=1

Click the format button, fill tab, choose a colour and ok out.

If you want colour in the plain rows repeat the above but use this formula and a different colour.

=MOD(ROW(),2)=0

and if i do a sort and rearrange the cells, does the alternating color stay?

THANK YOU SIR!

one more question...

how do I mark this as "answer"?

THANK YOU SIR!

 

one more question...

 

how do I mark this as "answer"?

 

Hi,

There's a button in my reply that you mouse click on.

Hi,

Another simple way is to convert the range into a Table

1. Select the range of cells (where first row of selection is the header row and the headers should be in Bold or Italic)

2. Press Ctrl+T > OK

The process above will band alternate rows in colours.  To change the colours, select any cell in the Table and in the Table Tools yellow button in the title bar of your Excel file, select any other design.

Hope this helps.

I DONT SEE IT, HIGHLIGHTED EVERYTHING, STILL DIDNT SEE IT

Hi,

I'm afraid that only the person that posted the question; and I understand Moderators, can see it so I can't and this probably goes a long way to explaining why so many correct answers are not marked as such by the OP.

I suspect those that own and  maintain this forum will continue to occupy themselves worrying about things of vital importance like modifying the MCC badge and abuse of the 'Content Curator' badge and  continue to ignore the on-going problem of so many correct answers not being marked correct by the OP because it isn't intuative. Such is life!!

I suspect a Mod will mark this as answer in due course, thank you for trying.

Just not showing on my end, best i could do was to like the answer.  I can provide screenshot.

I really like being able to mark a post as the answer as it helps future searchers.

Just not showing on my end, best i could do was to like the answer.  I can provide screenshot.

 

I really like being able to mark a post as the answer as it helps future searchers.

Hi,

I would suggest that posting the screenshot here would be a good idea.

I have no idea whether it's significant but I note that this wasn't posted as a question, it was posted as a discussion. Can you mark a discussion as answer?