Thread: format cell on other cell infromation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Maarten Maarten is offline
external usenet poster
  
Posts: 16
Default format cell on other cell infromation
I want to change the format of a cell depending on another cell's number. I
am looking for something like this:
For CELL A2=IF(A1=1,set the fill color to red, set the fill color to green)

Can anybody tell me th function for this setting color or other Cell
properties?
Reply With QuoteReply With Quote