Excel - Change colour of cell with max number of random selections

Question

Say I have 200 rows of data, mixed with text and numbers on excel such as below:

name | surname | dummy number | number 1 | house name | number 2 | father name | number 3
-----------------------------------------------------------------------------------------
Joe  | Smith   | 1            | 0.123    | Test       | 0.456    | Paul        | 0.789
Mark | Jones   | 32           | 0.321    | Test       | 0.555    | Michael     | 0.777
Luke | McKenney| 12           | 0.888    | Test       | 0.121    | Hank        | 0.333

and so on for around 200-300 columns.

Let's say I want to make the maximum number (from number 1/2/3) bold in each row. I could do it using a conditional formatting, however it would take me forever since I have a lot of rows.

Answer 1

This could easily be done with conditional formatting.

Assuming the numbers are in columns D, F and H and the data starts in row 2.

1. Select the rows of data from row 2 down, with example data that's A2:H4.

2. Goto Format>Conditional formatting...

3. Select Use a formula to determine which cells to format.

4. Enter this formula.

    =D2=MAX($D2,$F2,$H2)

5. Click Format... and set the formatting you want.

6. Click OK.

This is how the supplied data looks after the formatting is applied.