Conditional formatting based on value in table or query

Mary Edwards

New member
Local time
Today, 03:28
Joined
Jun 17, 2020
Messages
10
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!
 
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.
 
see demo of Conditional Format.
 

Attachments

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
 

Users who are viewing this thread

Back
Top Bottom