Conditional Formatting
 

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

Conditional Formatting
 

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

Conditional Formatting
 

On Dec 20, 5:35*am, Bernd P wrote:
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