Conditional Formatting Help

[itsgrady]

Need to highlight the adjacent cell to the right of the cell that is min in a given row. E4, G4, I4, k4, M4, O4, Q4, S4, U4 are the cells where the minimum value are. F4, H4, J4, L4, N4, P4, R4, T4, V4 (text cells) are the adjacent cells to highlight when the minimum value is found.

Example - if E4 is the minimum in the row. E4 and F4 should be highlighted.

Thanks for the help.

 

[itsgrady]

Try:

=LARGE($E4:$V4,COUNTIFS($E4:$V4,">0"))=IF(ISNUMBER(E4),E4,D4)

With E4 to V4 selected

This solution worked great. Thank you so much for your help!

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.