Cell format

[English Rob]

Hi all ..

I am setting up my metrics spread sheets for next year and i'm wanting
to format a cell so that the information changes color depending on value.
For instance, lets say Bob has a target of $250 but he is below that number, I would
want that figure to automatically turn red. If Bob was above that number I would want that
to figure to automatically turn green. $250 to remain black.

I have 2 other metrics where i'm looking for the same idea.
One is in the form of a percentage and the other a number.

Any help/advice is appreciated.

Thanks

English Rob

[Danerida]

You can use conditional formatting to handle this. Look it up in the help menu.