Conditional Formatting

[Neon520]

Hi Everyone,

I would like to present my report in a "readable" manner.
Here is what I essentially want:
Since there are X amount of lines for each item my report for Y amount of
items, I would like to have a Conditional Formatting that will Color the
group of one item in a certain color. May Cris-Cross between grey and white
if possible.

Is there a way to do this? I don't know how to do this since the amount of
lines per item vary from item to item.

Thanks for any suggestion.

Neon520

 

[Bernd P]

Hello,

If A1 contains your starting row (first row to format) and A2 contains
X then apply conditional format formula
=AND(ROW()>=$A$1,MOD(ROW()-$A$1,$A$2)=0)
for your cells(rows) you need to format.

Regards,
Bernd

 

[Robert H]

Hello,

If A1 contains your starting row (first row to format) and A2 contains
X then apply conditional format formula
=AND(ROW()>=$A$1,MOD(ROW()-$A$1,$A$2)=0)
for your cells(rows) you need to format.

Regards,
Bernd

actually it was because there was an alert prompt active and I did not
realize it. Too many windows open at once...

Thanks to ypou both for replying.
Robert