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.
I've tried defining by name & attempts with VBA, but to no luck.