Alternate Row color on based on non-blank cell

buzz71023

Active Member
Joined
May 29, 2011
Messages
280
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.

Code:
=MOD(ROW(),2)=0
 

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,332
Maybe...

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

M.
 
Last edited:

Forum statistics

Threads
1,084,878
Messages
5,380,415
Members
401,673
Latest member
Ali Balleya

Some videos you may like

This Week's Hot Topics

Top