Remove Color every other row

[Dick7Access]

I have googled this for a long time. How to remove color from every other row. Every thing I googled tells me how to add color.

 

[Minty]

It's set in the Detail section format properties - alternate back colour.

Just set it to the same as the back colour above.

 

[pbaldy]

I was going to suggest that earlier, before I noticed the forum it was in..

 

[Gasman]

Dick,
You haven't said how you are implementing the colour for each row?
I would presume Conditional Formatting?. If so create a formula to do it. You could perhaps just use Row() whether Odd or Even?

 

[Dick7Access]

It was so long ago that I made it that I don't remember. That is the first thing I tried to remove the conditional formatting. I don't use excel much. I tried to implement Misty's suggestion but could not find the Detail section format properties. I did a google to find where it is located but came up dry there also. I am planning to make a work schedule for people working in TX with me in May so that I could color each person name a different color but first have to remove the color from every other line that my original template has..

 

[Gasman]

It was so long ago that I made it that I don't remember. That is the first thing I tried to remove the conditional formatting. I don't use excel much. I tried to implement Misty's suggestion but could not find the Detail section format properties. I did a google to find where it is located but came up dry there also. I am planning to make a work schedule for people working in TX with me in May so that I could color each person name a different color but first have to remove the color from every other line that my original template has..

That was because Minty thought you were talking about Access?

Alternatively have a look here. https://www.google.com/search?q=exc....69i57j0l9.11489j0j4&sourceid=chrome&ie=UTF-8

 

[Dick7Access]

https://www.google.com/search?q=exc....69i57j0l9.11489j0j4&sourceid=chrome&ie=UTF-8
That adds color, I am trying to remove color.

 

[Dick7Access]

see attachment

 

[pbaldy]

If you're trying to clear the colors, they're coming from Conditional Formatting:

 

[pbaldy]

By the way, you get to that via below. You can manage the rules or clear them.

 

[Dick7Access]

By the way, you get to that via below. You can manage the rules or clear them.

View attachment 89240

 

[Dick7Access]

Thanks Paul, That did the trick.

 

[pbaldy]

Happy to help Dick!

 

[Dick7Access]

I just looked it up in my meetings DB. The only time I have preached in NV was Las Vegas, 2002. I still need to get out there again. Are the casino buffets still great?

 

[pbaldy]

Are the casino buffets still great?

Depends on the casino.

Some are great, others...meh. I haven't been to one since the covid lockdowns (we haven't eaten indoors at a restaurant yet). I've heard buffets are open now but someone gives you the items you want rather than it being self serve.

 

[Minty]

I was going to suggest that earlier, before I noticed the forum it was in..

Ah Spherical objects...

In my defense it was late here.

 

[Gasman]

https://www.google.com/search?q=exc....69i57j0l9.11489j0j4&sourceid=chrome&ie=UTF-8
That adds color, I am trying to remove color.

That is a bit like saying 'That shows me how to put a tyre on a car'. I want to take a tyre off a car'?

 

[Dick7Access]

That is a bit like saying 'That shows me how to put a tyre on a car'. I want to take a tyre off a car'?

Here we don't say put a tyre on a car, or take a trye off a car, we say my TIRE is flat.