Resolved >>> Conditional Formatting Issue-Bolding lowest value in EACH ROW

**Japes** · 10-23-2007, 10:52 AM

I'm working in Excel 2007. I'm wondering if, with conditional formatting, there is a way to bold the lowest value/number, in EACH ROW? I've tried highliting all 1500+ rows in my worksheet, but what happens is that it bolds ONLY the lowest number in the entire worksheet, as opposed to the lowest number in EACH row.

Is there a way to do this, outside of doing the formatting for EACH and EVERY row, individually (Which would take forever with 1500+ rows)?

Any help would be greatly appreciated. This is a god send of a forum.

**NBVC** · 10-23-2007, 11:04 AM

after you select all the rows, go to the Conditional Format window and Select Formula Is... enter formula: =AND(A1=MIN(1:1),A1<>"")

where A1 is the top left most cell in your selection and 1:1 assumes you selection starts at row 1.

**Japes** · 10-23-2007, 11:10 AM

Ok, that didn't quite work. I did it, and, it highlighted SOME low values in SOME of my rows, but not all.

Edited to add:

Actually, I stand corrected. Even the bolded data is incorrect, in that many of the bolded items are, in fact, not the lowest values in their row.

**Japes** · 10-23-2007, 11:14 AM

Ok, figured it out. Thank you SOOOO MUCHH for your help with that formula. I really, truly appreciate it. Never could have done this on my own.

**Japes** · 10-23-2007, 11:47 AM

I can't get this to work in my MAIN worksheet, for some reason. I've tried everything that I can think of.

**NBVC** · 10-23-2007, 11:48 AM

Originally Posted by Japes

I can't get this to work in my MAIN worksheet, for some reason. I've tried everything that I can think of.

What is the exact range you are covering? Did you adjust the formula accordingly?

**Japes** · 10-23-2007, 11:51 AM

I believe I did, but, I'm a bit slow when it comes to this type of thing. I'm trying to cover J2 through BA5000.

This is what I entered.

=AND(J2=MIN(2:2),J2<>"")

**Japes** · 10-23-2007, 11:54 AM

And, that formula, in this worksheet, is not highliting anything at all.

**NBVC** · 10-23-2007, 11:54 AM

If you're not covering the entire row, then try:

=AND(J2=MIN($J2:$BA2),J2<>"")

**Japes** · 10-23-2007, 11:57 AM

That did it. You are amazing. Thank you once again.

**Japes** · 10-16-2012, 07:40 PM

Ok, so now I'm trying to bold the HIGHEST value in each row, starting with b2, and working my way to the right. Here is the formula that is in, but, it appears that it's bolding the cell directly to the LEFT of the highest value, instead of ACTUALLY the one with the highest value.

Any help?

=AND(B2=MAX($B2:$R2),B2<>"")