Remove Color every other row (1 Viewer)

Dick7Access

Dick S
Local time
Today, 05:31
Joined
Jun 9, 2009
Messages
3,885
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

AWF VIP
Local time
Today, 10:31
Joined
Jul 26, 2013
Messages
8,013
It's set in the Detail section format properties - alternate back colour.
1613421175143.png


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

pbaldy

Wino Moderator
Staff member
Local time
Today, 02:31
Joined
Aug 30, 2003
Messages
34,924
I was going to suggest that earlier, before I noticed the forum it was in.. ;)
 

Gasman

Enthusiastic Amateur
Local time
Today, 10:31
Joined
Sep 21, 2011
Messages
7,717
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

Dick S
Local time
Today, 05:31
Joined
Jun 9, 2009
Messages
3,885
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

Enthusiastic Amateur
Local time
Today, 10:31
Joined
Sep 21, 2011
Messages
7,717
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

Dick S
Local time
Today, 05:31
Joined
Jun 9, 2009
Messages
3,885
see attachment
 

Attachments

  • Template Work Schedule beaumont 2019.zip
    8.5 KB · Views: 6

pbaldy

Wino Moderator
Staff member
Local time
Today, 02:31
Joined
Aug 30, 2003
Messages
34,924
If you're trying to clear the colors, they're coming from Conditional Formatting:

1613435081863.png
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 02:31
Joined
Aug 30, 2003
Messages
34,924
By the way, you get to that via below. You can manage the rules or clear them.

1613435544776.png
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 02:31
Joined
Aug 30, 2003
Messages
34,924
Happy to help Dick!
 

Dick7Access

Dick S
Local time
Today, 05:31
Joined
Jun 9, 2009
Messages
3,885
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

Wino Moderator
Staff member
Local time
Today, 02:31
Joined
Aug 30, 2003
Messages
34,924
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.
 

Dick7Access

Dick S
Local time
Today, 05:31
Joined
Jun 9, 2009
Messages
3,885
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'? :D
Here we don't say put a tyre on a car, or take a trye off a car, we say my TIRE is flat.
 

Users who are viewing this thread

Top Bottom