Thread: shading alternate rows – support.office.com suggestion not helping :-{
View Single Post
 
Old 12-10-2019, 12:59 AM
eNGiNe eNGiNe is offline Windows 7 32bit Office 2010 64bit
Expert
  
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default shading alternate rows – support.office.com suggestion not helping :-{
support.office.com says
  1. select cells
  2. set up new formatting rule
  3. 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
File Type: png excelFormula.png (78.4 KB, 15 views)
Reply With Quote