EXECL中颜色函数实战.docxVIP

EXECL中颜色函数实战 The first question is about the selection of background colors: Assume that a, B, C, and D columns have data, the first line is the title, and the line 20, as sum ing that there is color in the A column (because you are saying that the entire row is a color) enter Colorl in El ctrl+f3, define the name, name Colorl, and enter =GET.CELL (63, Sheetl, A2), +RAND () *0 in the reference location (quotes not entered) enter 二colorl in E2 drag the formula to the twentieth line, or E20 5., and then E as the standard filter can. The second question is about the color of the font: Similar to