Help me use OR in conditional formatting better

[turbotime]

First, I'm sorry if this is somewhere else or if I should already know this!

I'm conditionally formatting a data array to highlight certain rows based on data in three columns.

Column one, easy, >100
Column two, easy, isblank()
Column three however can have multiple acceptable answers.

So heres the formula I'm using:
=AND($F20>100,,ISBLANK($J20),OR($G20=124,$G20=125,$G20=126,$G20=127,$G20=128,$G20=132))

Do I have to write out the final statement as such or is there a shortcut way to write out the numbers? like or($G20=124,125,126,127 etc..)

Because the numbers are not sequential I can't use the 124:128 or whatever. So is there something better?

Thanks!

[gak67]

You need to do it the way you have, but it could be written like:

Please Login or Register  to view this content.

This assumes G20 contains whole numbers only, and won't be something like 125.6.

[TMS]

Maybe this:

Please Login or Register  to view this content.

could be shortened a little to:

Please Login or Register  to view this content.

Regards, TMS