Conditional formatting IF function
I have 2 fields. Is there an easy way to conditionally format the second field if the first field is conditoinally formatted? I have set up field 1 so certain values in the field make the background of the field change colour depending on the value. I would like the second field to change colour when the first field does too.