Formula to change cell colour

[Chuckie1]

Hi. Does anyone know how to change the cell colour due to a sum increase or decrease? For example: if the amount is greater than 200, change cell colour to green. If under 200 change cell colour to yellow. Is it possible to format a cell to do this?

[NBVC]

Use Conditional Formatting..

Select Cell and go to Format|Conditional Formatting

Choose Cell Value Is >> Less than >> and enter =200

Click Format and choose colour pattern..

Click Ok, And Click Add.

Repeat for Cell Value Is >> Less than > =0

[Chuckie1]

Ahha! That's great. Thanks so much.