Alternate Row color on based on non-blank cell

[buzz71023]

I have a spreadsheet that alternates the color of a range (C5:J500) or (=$C$5:$J$500) in conditional formatting selection. This part work great.
The problem is most of these do not always have data.
I would like the color of each row (C-J) to alternate color only if there was data in column C.

So once there is input into C the shading would change (if it's not the white rows turn)

My current Conditional Formatting formula is below.

thanks in advance for any and all input.

=MOD(ROW(),2)=0

 

[Marcelo Branco]

Maybe...

=AND($C5<>"",MOD(ROWS($C$5:C5),2)=0)
or
=AND($C5<>"",MOD(ROW(),2)=0)

M.

 

[buzz71023]

=AND($C5<>"",MOD(ROWS($C$5:C5),2)=0)

Worked perfectly.

Thank you!

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.