軟體:EXCEL
版本:2007
假設我的資料如下..
B2 C2 D2 E2 F2 G2
B3 C3 D3 E3 F3 G3
B4 C4 D4 E4 F4 G4
B5 C5 D5 E5 F5 G5
. . . . . .
. . . . . .
. . . . . .
B50 C50 D50 E50 F50 G50
我要找出B2~G2、B3~G3、B4~G4...B49~G49、B50~G50各列中的最小值並上色
請問需要怎麼執行??
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.118.38.174
推
06/03 14:21, , 1F
06/03 14:21, 1F
→
06/03 14:22, , 2F
06/03 14:22, 2F
→
06/03 14:23, , 3F
06/03 14:23, 3F
→
06/03 15:56, , 4F
06/03 15:56, 4F
推
06/03 17:51, , 5F
06/03 17:51, 5F
→
06/03 21:06, , 6F
06/03 21:06, 6F
→
06/03 21:06, , 7F
06/03 21:06, 7F
推
06/03 22:41, , 8F
06/03 22:41, 8F
→
06/04 01:15, , 9F
06/04 01:15, 9F
→
06/04 14:35, , 10F
06/04 14:35, 10F
推
06/04 23:09, , 11F
06/04 23:09, 11F