Hi, I would like to ask...
Lets say...
---------A-----------B
1-----color
2
3-----color
*"Color" = the cell is not in default color format (white)
I wanted it to show me in column B that which cell in column A is formatted in cell color.
Is it correct for me to use B = CELL("color",A) ? (where A= A1, A2 ; B= B1, B2 & etc)
And I have read the Excel Help file countless times on this function... Can anyone please tell me what does it mean by "Negative Values" in the CELL's color function?
" "color" -- 1 if the cell is formatted in color for negative values; otherwise returns 0 (zero). "
Thank you in advance!
Bookmarks