Hi,
I need a code, which would enable me to return the color index of a colored cell (colored via conditional formatting). If there is a colored reference cell, return the respective color index in next cell. I use Excel 2007. I need it only for four colors – red, blue, yellow and green. If the cell is not colored, return 0. I have tried some code, which is out on the net, without success, it does not work.
Thank you very much!
I need a code, which would enable me to return the color index of a colored cell (colored via conditional formatting). If there is a colored reference cell, return the respective color index in next cell. I use Excel 2007. I need it only for four colors – red, blue, yellow and green. If the cell is not colored, return 0. I have tried some code, which is out on the net, without success, it does not work.
Thank you very much!