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
<tbody>
</tbody>
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
| min | max |
| 4.5 | 5.5 |
<tbody>
</tbody>
