conditional formatting - shade alternate rows dynamically

[DDT~123]

Greetings all - I have a spreadsheet with data in range B8:AB200. Sometimes the range would be less than row 200. I'm needing to shade every other row, except if the bottom most row is blank. In other words, sometimes every other row from B8:AB164 would need to be shaded if B165 is blank.

 

[Joe4]

Select rows 8:200 and enter this Conditional Formatting formula:

=AND($B8<>"",MOD(ROW(),2)=0)

and choose your fill color for your shading.

 

[DDT~123]

Thank you! It worked well! I don't suppose there's an easy way to maintain the same every other row when using the data filter/sort is there? No biggie if not.

 

[Joe4]

Thank you! It worked well! I don't suppose there's an easy way to maintain the same every other row when using the data filter/sort is there?

Since it is working off row number, I don't think so. Conditional Formatting cannot determine which row numbers are visible or not.
Something like that would probably require VBA.