I have a user form which asks the user to select a product they are about to test. Each product has different ranges.
Example of ranges:

Product Name Product Weight Product Length
xyz10 120 (+or-5) 190(+or-1.6)
xyz15 133 (+or-5) 241(+or-1.6)
xyz20 144 (+or-5) 292(+or-1.6)
xyz25 156 (+or-5) 343(+or-1.6)

So if product xyz20 is selected and the inputted weight into designated column ("E") is above 149 or below 139 (acceptable weight range)the cell should turn red automatically or after the enter key or even another cell is selected. Otherwise if the value is within acceptable weight range 139 to 149 the cell will turn green automatically or after the enter key or even another cell is selected.

sorry how it turned out. Hope it make sense.

Hi

If the Excel sheet and Range is constant you can add Conditional Formatting on the Sheet itself. OTH, if you want to have it dynamically, try using:

http://vbadud.blogspot.in/2009/08/ho...ons-using.html

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)