Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 14
Default 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")
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default 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")

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,081
Default 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")

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting Question Romeo3891 Excel Discussion (Misc queries) 2 February 10th 09 01:54 AM
Conditional Formatting Question whwar_9739 Excel Discussion (Misc queries) 2 October 31st 08 11:03 PM
Conditional Formatting Question pivot table Excel Discussion (Misc queries) 4 August 17th 08 02:50 AM
Conditional Formatting Question pivot table Excel Worksheet Functions 1 August 17th 08 02:38 AM
Conditional Formatting Question mwevans1234 Excel Worksheet Functions 2 May 24th 06 10:37 PM


All times are GMT +1. The time now is 04:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"