How to automatically format a table in Excel?

Question

I have a table in Excel. In each row, I want to highlight the columns corresponding to the maximum value in this row.

For example, if I have this table:

0 1 2 3

4 5 3 5

8 9 3 4

I want to highlight 3 lines 1, 5 in line 2 and 9 in line 3.

How to do it automatically?

THANK!

Answer 1

Excel 2008 "" "". " ", " ...". " ". " ". " ", "" 1 % . "", .

, , , .

Answer 2

, , . , , MAX (range_name) , .

Answer 3

, . (E) -, :

   A   B   C   D   E
1  0   1   2   3   =MAXA(A1:D1)
2  4   5   3   5   =MAXA(A2:D2)
3  8   9   3   4   =MAXA(A3:D3)

:

For A1: =IF(A1 = $E$1, 1, 0)

, . , , $E $1 , , .

, . , VBA.