Conditional Formatting Question with 'OR'
 

Is "OR" operator allowed in Excel conditional formatting? If so is there
something wrong with this formula - it does not seem to be working?

=OR(TRIM(K3)="PENDING","INACTIVE")

Conditional Formatting Question with 'OR'
 

Hi,

Your using the wrong syntax, this will work as a CF

=OR(TRIM(K3)="PENDING",TRIM(K3)="INACTIVE")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Steve Stad" wrote:

Is "OR" operator allowed in Excel conditional formatting? If so is there
something wrong with this formula - it does not seem to be working?

=OR(TRIM(K3)="PENDING","INACTIVE")

Conditional Formatting Question with 'OR'
 

=OR(TRIM(K3)={"PENDING","INACTIVE"})

"Steve Stad" wrote:

Is "OR" operator allowed in Excel conditional formatting? If so is there
something wrong with this formula - it does not seem to be working?

=OR(TRIM(K3)="PENDING","INACTIVE")