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

Mary Edwards

New member
Local time
Today, 08:30
Joined
Jun 17, 2020
Messages
9
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

Well-known member
Local time
Today, 03:30
Joined
Apr 9, 2015
Messages
4,003
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

..forever waiting... waiting for jellybean!
Local time
Today, 16:30
Joined
May 7, 2009
Messages
15,048
see demo of Conditional Format.
 

Attachments

  • RAG.accdb
    460 KB · Views: 74

Mary Edwards

New member
Local time
Today, 08:30
Joined
Jun 17, 2020
Messages
9
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

Top Bottom