G Guest Oct 24, 2003 #1 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!
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!
R Ron de Bruin Oct 24, 2003 #2 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
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
D Debra Dalgleish Oct 24, 2003 #3 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
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
