Hi,

I have data of 100x150 in a excel sheet. I have min/max for each column. I need to find the data out of range of that min/max for each column. i.e. data which falls below min and above max. I can use New formatting rule with not between Min/Max for one column. But I need same rule applied for other 149 columns with different min/max limits. Excel throws error if I select entire sheet.

Is there a way I can achieve?

Also, if any macro that I can use.

Thanks,
PP