I am hoping someone can help out here....

This may sem like an odd request

I am trying to populate a range of cells with a specific value based on the color of the cell. For example I have a data from cell A1:Z85. If any of those cells are green I want to replace the value with a value that is in cell A105.

Reason for the ask...I import weekly data and the data that is incomplete comes back in a green cell and i need to be able to change that

thanks in advance