shading alternate rows – support.office.com suggestion not helping :-{

		Microsoft Office Forums > Microsoft Excel > Excel
shading alternate rows – support.office.com suggestion not helping :-{

FAQ

Thread Tools

Display Modes

12-13-2019, 12:34 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

I also think the problem is you have different separator defined in Regional Settings. Considered your posting time, it looks like you are from Europe, so probably the formula must be

Code:

=MOD(ROW();2)=0
or when you want to format based on table rows instead of sheet rows, then like
=MOD(ROW() - ROW($A$1);2)=0

Tags

fill colour, formatting rule

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Office Support Issue	ReallyFrustrated	Office	1	12-18-2018 03:14 PM
Word VBA: Helping someone new	femagu	Word	1	02-21-2014 09:33 AM
Office Help, Tech Support	chuckmg@acm.org	Chitchat	2	12-04-2013 09:10 PM
Office support saying my network is not clean	Cassera	Office	1	09-29-2013 10:43 PM
Office Support for Access 2010	alexb123	Office	2	01-28-2013 04:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:17 PM.