=OR($F$1=5,$O$1=5000)This formula works fine if both conditions are met. How
would you rewrite it to show in red if only one or both conditions are met.
Say there is only a 5 in F1 and no 5000 in O1 or 5000 in O1 and no 5 in F1. I
need it to show in red if only one condition is met. Thanks in advance!!!