Forum Discussion
Select all cells using certain font color -then prepend a charachter (up arrow) to content.
lsuel65 If you can't get your hands on the source data and calculate a plus or a minus, you would need VBA to read out the font color for each cell. Not something I'm getting involved in. Sorry!
So the colors come from data from "insights" in an online account. it must be *somewhere* I don't have access to that data. Here's what it looks like. I was hoping to just select all "green" cells and add and "up" arrow. Mostly because it seems weak to just have a color indicate positive and negative. Furthermore status can't be determined when printed out easily unless in color.
lsuel65 If you can't get your hands on the source data and calculate a plus or a minus, you would need VBA to read out the font color for each cell. Not something I'm getting involved in. Sorry!
- Ok of course! Thank you for offering your help! Neither of us need to get involved more than this. I appreciate your explanations! 🙂