Ann_BBO
05-21-2010, 07:13 PM
Hi All,
I have a series column data. For each column, i would like to find out the minimum colorindex. See the attached file.
Example.
In Column B, all column cells are None of interior colorindex so the result shown in B15 = None Interior colorindex.
In Column C, it have a Orange interior colorindex (=45) in one cell so the result are shown in C15 = Orange interior colorindex.
In Column D, it have a Purple interior colorindex (=7) in one cell so the result are shown in D15= Purple interior colorindex.
In Column H, it have a Red, Purple, Orange interior colorindex in one of the column cells respectively. As the red colorindex are the minumum index (=3) and so the H15=Red Interior colorindex.
Is using the excel format function or need to write the VBA code to achieve this goal?
Thanks
Ann
I have a series column data. For each column, i would like to find out the minimum colorindex. See the attached file.
Example.
In Column B, all column cells are None of interior colorindex so the result shown in B15 = None Interior colorindex.
In Column C, it have a Orange interior colorindex (=45) in one cell so the result are shown in C15 = Orange interior colorindex.
In Column D, it have a Purple interior colorindex (=7) in one cell so the result are shown in D15= Purple interior colorindex.
In Column H, it have a Red, Purple, Orange interior colorindex in one of the column cells respectively. As the red colorindex are the minumum index (=3) and so the H15=Red Interior colorindex.
Is using the excel format function or need to write the VBA code to achieve this goal?
Thanks
Ann