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?

format cell on other cell infromation
 

Try conditional formatting.