I have data in rows A through F. I have an IF formula in Row F to give me a text output if the data in Row B is the highest value or the lowest value. I also have used the conditional formating so those text outputs are a certain color text and fill. My question is this: Is there a way to make rows A-E, where the hightest or lowest value in column F appear, show up in the same formatting? In other words if a row in column F looks like this: HIGH, can I get the other cells in that row to look the same way with a formula or some conditional formatting?

Hope that is clear enough.

Mike