Conditional formatting based on value in table or query (1 Viewer)

[Mary Edwards]

I am needing to conditionally format 16 textboxes but the perimeters may change.
We are looking at a RAG rating (Red, Amber, Green) currently red is <15 amber is >14 and <23 green is >22. However in the future we may want to move the boundaries, ie have red as <10. Is there a way of having this information stored and able to be edited that will subsequently change the formatting rules?

I have tried as below
I have a table where only 1 record is allowed then Expression is <"Table"!Red!
I have a query which is a sum of Red field in that table Expression is <"SumQuery"!Red!
I have a textbox in a form based on the table and tried <"Form"!Red textbox!

 

[Ranman256]

Make a table with your color ranges:
red ,0,15
amber,14, 23
green, 22

then the form would import the values,then set the color ranges.

 

[arnelgp]

see demo of Conditional Format.

 

[Mary Edwards]

The problem is, the boundaries are set in one table (and I've tried a Sum Query) and the form is based on a different one. It just comes up with #Name? when i go into design view

 

[isladogs]

Here is another example Colour Conditions - Mendip Data Systems. That example uses more than three colours but you can adapt as required.