Conditional Formula help

[Guest]

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

 

[Guest]

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

"IF F1 OR O1 = 5000, THEN [your condition], ELSE [other condition]"

 

[Dave Peterson]

I'd say try your conditions again.

=or() will return true if one or more of the conditions are satisfied.

 

[Guest]

I have tried your conditional format formula and it works, the only
difference is i took out the $ that make the cell references absolute. If
you are going to copy this format to another cell that is relaive, this is a
must, otherwise the formula worked fine.

 

[Dave Peterson]

I kept the absolute references since the original poster had them in his first
post.