Return MAX value based on set criteria

Try:
=MAX(IF($D$10:$D$24="A. Lighting",$H$10:$H$24)
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Easiest way that I can think of is to reference the cell with the formula (either Bebo's or Phuocam's) combined with the text value in column D.
Example if Phuocam's formula is being used in cell X3 and you want to highlight the max value in column H then use the following formula as a conditional formatting rule and applied to your range (ex. H10:H24):

Formula:

=AND(D10="A. Lighting",H10=X$3)

If more/better explanation is needed please attach a copy of the file from which the screen shot in post #1 was made.
To attach a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.