highlight the highest value in a row by formula

[tomas]

Hello

I have not used formulas for conditional formatting yet, but I do not think what I want to accomplish is possible by other resources. In sample file there is bunch of numbers in columns and rows and I want to conditionlaly format the highest value in every row.

Can someone help ?

thanks in advance

 

[Hui]

Tomas

Select A1:F10
CF, Remove existing CF if any
CF, New Rules, Use a Formula
=A1=max($A1:$F1)
Select a format
Apply

This says if the cell (This applies to every cell but uses the Top Left cell (A1) as a reference / example) is equal to the maximum value in the Row, Note the $ signs

Apply the format

 

[tomas]

Hui

Thank you, its working . I heard that there must be boolean logic involved

 

[Somendra Misra]

Hi Tomas,

Just another method will be:

1. Select one row (A1:F1)
2. From the conditional format drop down Select Top Bottom Rule.
3. Now Select Top 10 items and change 10 to 1 in the option box.
4. Now with format painter apply the format on each row.

Of course this method is tedious if rows are lot and than Hui method will apply the CF at a single shot. Plus this method will create as much rule as many rows are there.

But just another method to share.

Regards,

 

[tomas]

Hi Somendra

Hehe I was aware of your suggetion to the point that I can use the format painter. These is quite helpful knowledge