Conditional formatting to show two greys, but when group changes

[tonywatsonhelp]

Hi Everyone,
I've been trying to do this all weekend but cant get it right?

In Column A I have book names
In column B I have the chapters
using conditional formatting,
I'd like to create a striped backgrounds of greys light and darker for each different book name.
so i can see the separation of the books easier
if possible?

please help if you can

thanks
Tony

 

[Joe4]

I think we need to know more about your data (posting an example of it would be helpful).
Is column A filled in for every row, so that the book name keeps repeating?
Or does a book name exist in column A, then there are a bunch of blank rows going down column A until the next book name appears?

 

[Joe4]

If your have "gaps" in column A between books, and if you wanted to do an alternating patter (of white and gray), you can select rows 1 down to the end of your data, and enter this Conditional Formatting formula:

=ISODD(COUNTA($A$1:$A1))

and choose a gray fill color.

If you wanted the other color to be something other than white, then add a second CF condition, following the exact same process, but use this as the other formula:

=ISEVEN(COUNTA($A$1:$A1))

and choose some other color.

 

[tonywatsonhelp]

Wow,
thats Joe, works just as i need it
Thanks
Tony

 

[Joe4]

You are welcome.