Cell Value

[seanbtrini]

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!

 

[Guest]

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.

 

[seanbtrini]

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.
Understand, well is there a way to tally up all the green cells?






- Show quoted text -