Is there any way to use the mod row function to shade alternative rows, based
on whether cells have any value in them.
I want to select a big range (eg A:G) and only shade alternative rows (A:G)
once data is place in cells.

the mod row function shades regardless if there is data in or not.