Conditional formatiing - can it refer to a different field?
I apologise if this is a dumb question - Can I use conditional formatting based on the value of another field in the same record?
I am making a register, and want the colour of the date fields to show how far students have paid up to.
For example if the "paid" field contains "60" then "January" field background is blue, if the "paid" field contains "20" then "January" field background is red.
All the information I have found seems to use the value in the field itself compared with a fixed value or the value of another field.