Conditional Formatting Shading Rows Based On A Single Cell

You have zero info in your sheet explaining what you're trying to accomplish. Maybe it is easier to explain it, after all.

In the spreadsheet, you can see that A7 to A9 and A15 to A16 and shaded. I did this manually using fill color. What I want is to do that in conditional formatting. Obviously I can't do that with a simple =MOD(ROW(),2)=0 formatting.

For one thing, in column A some cells are merged (ie: A7:A9). So how do I go about doing a conditional format to make it look like the sample spreadsheet without having to do a manual fill color?

Does that make sense?

Thank you very much for the reply. I tried your formula and this is what I got.

sample2.xlsx

I modified the spreadsheet to reflect how I want it to look. It looks very close but not quite there yet. I do apologize, as I am very much a novice when it comes to Excel and I certainly appreciate the people that help me in this forum


Thanks!

Select your range, starting with A2. Use this formula for conditional formatting. Change the 1 to a 0 if you want every other row highlighted.

=MOD(COUNTA($A$2:A2),2)=1

Thank you BenMiller.

It didn't quite work. This is the result of what I got using your formula.

sample2.xlsx

Sorry didn't realize you were dragging across columns. Lock the second A :

=MOD(COUNTA($A$2:$A2),2)=1

Yup that works. Thank you so very much and have a wonderful day!

No problem Glad I could help ... Appreciate the feedback!