Yes it is possible to change a cell value based on another cells colors. I
wouldn't recommend doing it becuase if the other cell color changes th ecell
with the value will not change. for some strange reason, excel doesn't
update a sheet when the color of the cell changes. Not sure why.



" wrote:

Hi, is it possible to assign a cell value of "0" or "1" to a cell
based on the condition of the cell next to it.

A1, result of formatting = Green, make B1 "1".
A1, result of formatting = Red, make B1 "0"

Thank you!