Conditional Formatting across entire record - how?

[Chaz]

Most of my forms are continous and are basically an 'excel' view of the data.

I can conditionally format boxes to change colour on content but how do I change an entire row's colour based on what is written in one specific field?

For example I need to have all open orders yellow (entire row of info or background colour) and all closed orders green.

Thanks in advance.

 

[Chaz]

Wanted to add - I dont know much VBA so would prefer to do it via the normal options if that is possible?

 

[missinglinq]

What indicates an 'open' or 'closed' order? Do you have a field that says 'open' or 'closed' or id it a checkbox, and if so, what indicates closed?

 

[Chaz]

What indicates an 'open' or 'closed' order? Do you have a field that says 'open' or 'closed' or id it a checkbox, and if so, what indicates closed?

It is currently a word in a field which is written. I will change it to dropdown / combo box. Status will therefore either be Open or Closed.

 

[pbaldy]

You can either use conditional formatting on all the textboxes, or add one large textbox that sits behind all the others, change the back style of the others to transparent, and format that one textbox. To do controls other than the one containing the test value, you use Expression Is.

 

[Chaz]

You can either use conditional formatting on all the textboxes, or add one large textbox that sits behind all the others, change the back style of the others to transparent, and format that one textbox. To do controls other than the one containing the test value, you use Expression Is.

Thanks - will try that.

 

[isaacski]

Hi Chaz,
I just came across this forum and I am having trouble doing what you stated you had no problem with. My form is exactly like you say a continuous form that mimicks an "excel" type view. I need to conditionally change each "cell" to turn gray if it says 1001. I would appreciate any help you could give me! I am also very new with VBA and though I can do it if necessary, I would prefer not having to use code. Thanks in advance for your help!!

 

[pbaldy]

Conditional Formatting is an icon on the ribbon or under Format in older versions.

 

[isaacski]

Conditional Formatting is an icon on the ribbon or under Format in older versions.

Wow. I am somewhat embarrased that I had to ask about something so simple. This worked perfectly. Thanks very much PBaldy!

 

[pbaldy]

No problem, and welcome to the site!