Conditional Formatting working improperly

**esupply** · 10-27-2009, 01:40 PM

Hello all,,i am having some trouble getting the conditional formatting to work the way i need it to ,,,i have attached a sheet with an example of what i mean and what i actually i need it to do,,,can you help please,,,,thanks

**NBVC** · 10-27-2009, 01:52 PM

Are you trying to highlight the lowest value in each row, A2:E2, etc.. or the lowest value in all of columns A:E?

**esupply** · 10-27-2009, 02:01 PM

In each row,,do you see how there is a blank column in between each set of five rows with data...Well each row with the data i have to find the lowest value out of each,,,i tried using the conditional formatting but i have to them 1 at a time for example i would have to highlight A1:A5, format it them highlight B1:B5, format it and so on,,,i hope you know what i mean,,,what im looking for is an easier way to do them in a bigger group or by row

**NBVC** · 10-27-2009, 09:31 PM

Remove all current Conditional Formatting

Select columns A to E and invoke conditional formatting, Manage Rules

Click New Rule, select use formula to.....

add formula:

=AND(A2<>"",A2=MIN($A2:$E2))

Click Format and select colour...

.. close.

Then select column E:K and repeat with formula:

=AND(E2<>"",E2=MIN($E2:$K2))

select format

and repeat for other column groups.