Validating Multiple Ranges

if it is possible please attache your workbook with dummy data.
please explain if any of cells(a1,a3,c1,c3) could be black or the same as each other.
Recording highest level of risk thats mean only value (low, medium, high or extreme) without info which cell have it ?

For now your task is quite difficult to understand how it should works

Best Regards
MaczaQ

Hello

if it is possible please attache your workbook with dummy data.
please explain if any of cells(a1,a3,c1,c3) could be black or the same as each other.
Recording highest level of risk thats mean only value (low, medium, high or extreme) without info which cell have it ?

Here is an example spreadsheet. Hopefully this helps to explain. I need to evaluate each series of four cells and record the highest value (which I have manually added) as a varaible.

Thanks

Happy Hole

Okay so here is what I have. It works, but as I said doesn't look efficient:

Please Login or Register  to view this content.

Hope someone more advanced than I am can assist. This is all part of a form for employees to fill out that is becoming increasingly more complex, so perhaps I'm being overly sensitive about how big all this code is getting ....

Thanks.

Happy Hole

Does the attached help

Hi Richard

Thanks - I might be able to work with it if I can configure the numbers. Currently 4 x medium looks like it evaluates to "Extreme".
Hoping to get a VB version because the stored variable is then used elsewhere.

Thanks.

Happy Hole