Hello All,
I would like to create a script that looks through a worksheet for cells in which the text is a certain color.
Any cell that is that color, I would like the script to copy the cell and paste the value (all cells are currently formulas)
Could anyone help me figure out how to do this?
Thanks!
EDIT: Sample file attached, the idea would be able to run a script that copy's all the blue text in worksheet "linked" and pastes it as the underlying values
Bookmarks