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

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

I'd say try your conditions again.

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

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

--

Dave Peterson

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" wrote:

I'd say try your conditions again.

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

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

--

Dave Peterson

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

REST wrote:

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" wrote:

I'd say try your conditions again.

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

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

--

Dave Peterson


--

Dave Peterson