Conditional Formatting

[kanjeep]

I am needing to set the conditional formatting on a report dependant on values being 1,4,7,10 or 2,5,8,11 or 3,6,9,12. Is there any way I can do this inside the formatting tool? If i put commas between the numbers it tells me it is invalid.

 

[pbaldy]

Don't know if you can use an In clause in conditional formatting, but try it:

Field In(1,4,7,10)

If it doesn't work, you'll need to do this:

Field = 1 OR Field = 4 OR ...

 

[kanjeep]

Only three 'conditions' are available for this formatting. No 'In' clause is available(although that would be nice).

 

[pbaldy]

I know there are only 3 conditions, but each can have "And" & "Or" clauses within it.

 

[kanjeep]

I tried using the "Or" clause and it allows it but the conditions aren't met.

Condition 1
Field Value Is equal to 1 Or 4 Or 7

Condition 2
Field Value Is equal to 2 Or 5 Or 8

Condition 3
Field Calue Is equal to 3 Or 6 Or 9

 

[pbaldy]

Look at how your structure is different than the example I gave you (hint, you want "Expression Is" rather than "Field Value Is").

 

[kanjeep]

Changed to 'Expression is' and now all rows are met by Condition 1 and should'nt be. My field values are 1,2,3,4,5,6,7,8,9,10,11,12.

Condition 1
Expression Is 1 Or 4 Or 7 or 10

Condition 2
Expression Is 2 or 5 Or 8 Or 11

Condition 3
Expression Is 3 Or 6 Or 9 Or 12

 

[pbaldy]

It should look like:

[FieldName] = 1 OR [FieldName] = 4 OR [FieldName] = 7 OR [FieldName] = 10

replacing "FieldName" with the actual name of the field.

 

[boblarson]

It should look like:

[FieldName] = 1 OR [FieldName] = 4 OR [FieldName] = 7 OR [FieldName] = 10

replacing "FieldName" with the actual name of the field.

And, just in case it wasn't clear, keeping the brackets.

 

[kanjeep]

Now THAT makes sense!!!!

Thanks Paul!!!!