Cell text based on another cell color

Hi all,

I'd like to populate a cell with the text of another cell if it is a certain color. Say cell A1 is red and has the text ABC written.I would like something that would populate like this for example:

IF(Cell A1 is Red, populate cell B1 with text from A1) .... so that B1 would just say ABC in it now.

I know there is no built-in function based on cell color, but i have been able to return a value using a cellcolor function. Currently, my function is =IF(cellcolor(A1)=3, "true", "") but this doens't return the text from cell A1.


I appreciate any help thanks!

Are you using conditional formatting to make the cell red? If so you are going to have issues with the route you choose. Conditional formatting would probably work for B1 too.

thanks for the reply. No, the color is being manually filled. I've seen all sorts of code for color and text functions, but nothing that outputs the text of a cell into another based on color.

thanks!

Try:

Please Login or Register  to view this content.

Thanks stnky. now the way my table i am pulling this info from is organized, i want to search columns D3:D21, H3:H21, L3:L21, etc. Currently, it is copying text from a red cell outside my desired range. Could you tell me how to alter my code to change my LR? thanks!

I am not 100% sure what you mean but give this a try and see if it works for you:

Please Login or Register  to view this content.

Looking good!

Thanks!