Select ColA:G and try the below CF formula..Make sure the active cell of your
selection is in Row1

=AND(MOD(ROW(),2),COUNTA($A1:$G1))

--
Jacob (MVP - Excel)


"wynand" wrote:

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.