Thread: shading alternate rows – support.office.com suggestion not helping :-{
View Single Post
 
Old 12-13-2019, 12:34 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
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
Reply With Quote