Coloring cells based on positive or negitive numbers

[Guest]

I have a worksheet that I would like to set up so if the number in a
particular cell is a positive number the cell is green. If the cell has a
negitive number the cell turns red. All of the cells in question are in the
"R" column and are in %.

Thank You.

 

[Guest]

Checkout conditional formatting:

http://www.contextures.com/xlCondFormat01.html

 

[Bob I]

Click, Format, Conditional formatting