Thread: Cell Value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] seanbtrini@gmail.com is offline
external usenet poster
  
Posts: 11
Default Cell Value
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!

Reply With QuoteReply With Quote