Highlighting entire row based on a single cell value

**icerman** · 10-11-2012, 05:24 PM

Hi,

I have a bunch of numbers in column N. I used " =N1=MIN(N:N) " to highlight the min value in the column. However, I would like to highlight entire row which includes that min value.

Is there any way to do that??

Thanks in advance

K.

**benishiryo** · 10-11-2012, 09:06 PM

hi icerman, welcome to the forum. select the range you wish to highlight, eg from A1 to P10. go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=$N1=MIN($N:$N)

**icerman** · 10-14-2012, 12:40 PM

Thanks for the tip.

I tried in a sample sheet, it worked. But it is not working in my sheet. I am not sure what is wrong but i ll try to figure it out.

Thanks again...