Lookup based on conditional formatting?

Originally Posted by Greg M

Take a look at the attached workbook.

Column D contains the percentages which correspond to the options selected by the user.
Cell D4 contains the maximum value of these percentages.
Columns A and B are conditionally formatted so that the option and percentage cells corresponding to this maximum percentage are highlighted.

Pressing the F9 key recalculates the various random numbers on the worksheet, and the appropriate option and percentage cells are again highlighted


I hope I've understood your requirements and that this helps - please let me know how you get on.

Regards,

Greg M

Now I need C5 to be populated with the highlighted result from Column A.