=IF(OR($F$1=5000,$O$1=5000),[THEN condition],[ELSE condition])

"IF F1 OR O1 = 5000, THEN [your condition], ELSE [other condition]"
--
Brevity is the soul of wit.


"Richard" wrote:

=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!!!