format cell on other cell infromation

[Maarten]

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?

 

[D.]

Try conditional formatting.