Creating a column checking all the spec limits saved as colum properties

[#1]

Hi all,

I am checking several parameters for some products, e.g. length and width. Each parameter is a column with spec limits as column property. Each row is the product. How do I automatically created a column called "InSpec" that tells me whether the product (row) is in or out of spec for all the parameters (columns) with assigned spec limits WITHOUT having to write an IF statement as a formula for the "InSpec" column. This is because I have tons of spec parameters to check (saved in a spec table). I already used a for loop to assign the spec limits as column properties, so I figured there might be a way to check for all the specs as once.

Thank you!

[#2]

JSL can do this. These posts have some ideas about what you could do

 How to get the row number of colored cells in a column and assign it a tag (say "1") in a newly crea... and Scripters Club Recordings: Tips and Tricks. And there are also other methods.

[#3]

Under the line:
Please vote here 🙏 is in spec (value) .