Hello All,
could I please get some help
Workbook 1 contains acceptable values of maximum and minimum alcohol level, this workbook is also used to extract other information such as product name and specification when working in another workbook (2). I would like to add alcohol column in workbook 2. when I enter id code, product name and specs are generated from Workbook 1 (currently using vlookup), so when entering data for the alcohol, I would like the formula will look at the values from workbook 1 and display it in red if outside the max or min range for a given product.
workbook1alcohol values
[TABLE="width: 0, align: left"]
<tbody>[TR]
[TD]min
[/TD]
[TD]max
[/TD]
[/TR]
[TR]
[TD]4.5
[/TD]
[TD]5.5
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
could I please get some help
Workbook 1 contains acceptable values of maximum and minimum alcohol level, this workbook is also used to extract other information such as product name and specification when working in another workbook (2). I would like to add alcohol column in workbook 2. when I enter id code, product name and specs are generated from Workbook 1 (currently using vlookup), so when entering data for the alcohol, I would like the formula will look at the values from workbook 1 and display it in red if outside the max or min range for a given product.
workbook1alcohol values
[TABLE="width: 0, align: left"]
<tbody>[TR]
[TD]min
[/TD]
[TD]max
[/TD]
[/TR]
[TR]
[TD]4.5
[/TD]
[TD]5.5
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]