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

eNGiNe · #1 12-10-2019, 12:59 AM

support.office.com says

select cells
set up new formatting rule
use formula =MOD(ROW(),2)=0

Tried this … Excel says "the formula you typed contains an error". Any suggestions? If I knew how to read that sort of formula, I would have written my own anyway!

p45cal · #2 12-10-2019, 04:14 AM

Could it be your locale requires a semicolon (;) instead of a comma (,)?

ProudLiberal · #3 12-10-2019, 05:09 AM

=if(mod(row(),2)=0,true,false)

ArviLaanemets · #4 12-13-2019, 12:34 AM

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

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