conditional formatting

conditional formatting active row or less.see the attached file
Book2.xlsm
SvgmassiveAsked:
Who is Participating?
 
byundtConnect With a Mentor Commented:
If you want to put the pink highlighting between sections only, select a cell in row 19 and change the formula for the second criteria to:
=AND(COUNTA($B18:$M18)>0,COUNTA($B19:$M19)=0,COUNTA($B20:$M20)>0)

The above formula requires the row before and the row after to contain data, but the row being formatted must be blank.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.