hi
Experts

I am working on excel sheet to compare the cell color index of 5 cell.
say CELL A, CELL B ,CELL C, CELL D, CELL E.

I have used cf to format the color of all cells. If CF condition evaluates
to be true then colour of cell A and
either CELL B or CELL C and
either CELL D or CELL E

colour becomes same.

what I am trying to do is to compare the cell colour index.
If colour index of CELL A
matches with colour index of either CELL B OR CELL C
and with colour index of either CELL D OR CELL E

then the colour index of CELL G should be same as the colour index of all
the compared cells.

Any easy solution greatly appreciated
Thnx