Conditional formatting greater than 60 entries (1 Viewer)

archy321

Registered User.
Local time
Yesterday, 19:38
Joined
Sep 10, 2018
Messages
11
Hello,

I was entering all the requirements for my conditional formatting and found that I think that there can only be up to 50 values that can be entered into the pop up box on the report builder. Is there any way to get more values than 50, or to have the multiple factors in one line such as "expression is instr([field], "one" or "two" or "three")>0

something like that?
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 19:38
Joined
Aug 30, 2003
Messages
36,118
I believe that's a hard limit. You should be able to have:

instr([field], "one")>0 OR instr([field], "two")>0 OR instr([field], "three")>0
 

archy321

Registered User.
Local time
Yesterday, 19:38
Joined
Sep 10, 2018
Messages
11
This works perfectly and I wont go over my hard limit! Thank you very much!
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 19:38
Joined
Aug 30, 2003
Messages
36,118
Happy to help!
 

isladogs

MVP / VIP
Local time
Today, 02:38
Joined
Jan 14, 2017
Messages
18,186
The limit used to be 3 CF conditions until a couple of years ago. In fact it still is using VBA.
I'm trying to imagine having anything like 60 conditions as in your app!
 

Galaxiom

Super Moderator
Staff member
Local time
Today, 13:38
Joined
Jan 20, 2009
Messages
12,849
Conditional formatting be really slow if it is very complex logic.

Another alternative may be to put all the logic into the query and derive another field which can then be used for assigning the conditional formatting with a very simple condition.
 

Users who are viewing this thread

Top Bottom