conditional formatting challenge

B

brendan

Here is my challenge:

I have already used all 3 conditions. I need one condition to execute when
a value = approved OR n/a.

my problem is that i can do one or the other, but no both in the same
condition- how do you do that?

thanks!
 
N

Norman Jones

Hi Brendan,
my problem is that i can do one or the other, but no both in the same
condition- how do you do that?
Click to expand...


Formula is: =OR($A$1="approvedd",$A$1="n/a")
 
M

Max

On the face of it ..
.. I need one condition to execute when
a value = approved OR n/a.
Click to expand...

Think using CF formulas in say, Condition 1 such as:

Formula is: =OR($A1="Approved",$A1="N/A")

(if the "n/a" within col A is text)

Or, if col A contains formulas which could evaluate to #N/A

Formula is: =IF(ISNA($A1),1,$A1="Approved")

could accomplish the desired conditional checks
 
Top