I have text returned from a formula in cell B27, I want conditional formatting to look at the value in B27, find that value in cells H21:H25, then highlight the cell directly next to it.
For example
I have the formula in cell B27 is returning the word Needs Imprv (It changes as new data comes...