Condition format

[rudi7109]

I have a list of numbers about 1000. want to Condition format in groups of 250 with a color. eg
If field = 500 then green


If field = 600 then red
etc
if I do it for each number (1000) I'll have 1000 condition formats is there a shorter way
Thank you

[ranman256]

use ranges : if val between 0 and 20 , blue

[pbaldy]

If you mean Conditional Formatting on the ribbon, they are applied in order, so your first test can be

[FieldName] < 251

the second < 501, etc.

[rudi7109]

Its random numbers so I can not use the < or between. 10210, 10213, 1055, 1061 and then the groups are also random eg 1,2,3,8,600,700 in group 1 and 9,20,800,901 in group 2 etc. Is it possible to create 4 lists and link each list to a condition. Its easier to modify a list than conditions

[pbaldy]

You can format on the group number if that's in your data. You can create a list. I'd have one list with all values and a field for group, not 4 lists. If you created 4 lists you'd probably have to use a union query to pull them together anyway. Join that list to your actual data and you have your group number to format on.