Microsoft Access conditional formatting to create alternate shaded rows


I am using Microsoft Access 365.  --- Microsoft Access  in the  form design mode.

I am using a continuous form with conditional formatting to highlight cells of certain conditions.
If there are no concerns, then I would like the background color of the cell to have alternate color shades from one  row to another.

Because I am using conditional formatting,  I have had to set the "Back Style" property to "Normal".  So, if no conditions are met, the background  color will default to  the "Back Color" property of that field (see Properties jpg)

I have not been successful.  I would appreciate any help.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Richard DanekeTrainerCommented:
If you set the default background to transparent, Access should let the standard alternate row formatting show.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
peispudAuthor Commented:
Indeed, this would work,  but conditional formatting then gets turned off for that field.
peispudAuthor Commented:
Richard Daneke  --- You were correct.  I was mistaken.

Thank you.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.