Format cell based on conditional fill color

[Robert_G]

I have one columns that conditionally fills the cell color based on a criteria. I would like the adjacent column to look at the first column and if the color is green, to display a word ex: "go". If there's no fill color, to remain blank.

I've tried defining by name & attempts with VBA, but to no luck.

 

[MARK858]

Just wrap it in another IF statement.

=IF($D2="","",your formula in post number 9)

 

[Robert_G]

 

[Robert_G]

Somewhere in my statement is false. I'm missing something. Can someone look at formula and see what I'm missing in the formula?

 

[MARK858]

Double quotes not single!!!!

 

[Robert_G]

Thanks!! Works perfect. A second set of eyes and a little guidance is what I needed. Thanks for all the help