Or you can also use VBA's WITH statement to write a code like below. For every column of data, the format will be changed if the “Color” is “Black”.
確定! 回上一頁