subfrom coditional formating if one field has value

[megatronixs]

Hi all,

I wanted to use a conditional formating when in a subform the field "Field_Name" has the value "Case Status New" and then the field "New_Value" should become orange color.

I guess it can be put togheter like a formula (expression) in the Edit Formating Rule.

Any clue how to do this?

Greetings.

 

[ConnorGiles]

Just going to take a stab for you

In conditional formatting try this code in an expression.

[Field_Name] = "Case Status New"

Then set the colour to orange

Hope this helped.

 

[megatronixs]

Hi,

Thanks for the help
I actually made it work before I saw your answer with this:

"Case Status New"=[Field_Name]

No clue if it should be like that, but it works.
I guess it is like in excel, many ways to do the same.

Greetings.

 

[ConnorGiles]

No Problems at all mate

Hope it goes okay from here on!

 

[megatronixs]

I took over a database from some one else and I need to add all those things they wanted 9 months ago
I still have plenty to add and as my knowledge is not that advanced I stumble across minor things like the above one, but with the great help from people in this form, I learned a lot

BIG THANKS TO ALL