I'm sure this is a common enough problem, but again it has me stumped...
How can I use conditional formatting to change font color or background color of one field, depending on the value of another field ?
e.g.
if the value in a field called gender is "Male" the name displayed in the name...