View Single Post
 
Old 12-13-2019, 12:34 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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