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-10-2019, 12:59 AM

eNGiNe

Windows 7 32bit

Office 2010 64bit

Expert

Join Date: Jan 2012

Location: Brussels [BE]

Posts: 745

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

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!

Attached Images

excelFormula.png (78.4 KB, 17 views)

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 09:34 AM.