Auto Fill Setting

[Chris]

is there a way to have the fill color of a cell determined (set) by whether the number in that cell is positive or negative?

Thanks!

 

[Ron de Bruin]

You can format a cell like that Chris

select the cells
Ctrl-1
choose number for example
and choose a red colored format you like

 

[Debra Dalgleish]

You can use Conditional Formatting to colour the cells. There are
instructions in Excel's help files, and here:

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