At 08:56 22/11/2007 -0600, Jim Cresap shouted:
IN ONE COLUMN I WISH TO MAKE ALL CELLS CHANGE THE NUMBER TO RED IF
130 OR ABOVE AND BLACK IF BELOW 130.
You can set the colour of cell contents conditionally using the
normal formatting of cells.
o Select the cells or - in this case - the entire column.
o Go to Format | Cells... or right-click | Format Cells... and then
the Numbers tab.
o In the "Format code" box at the bottom of the panel,
enter: [>=130][RED]General;[BLACK]General
This arranges that for values greater than or equal to 130, the
General number format is used with the text colour red, and for other
values the General format is used with text colour black. (You don't
need the second part if the text colour would otherwise be black by
default, in fact.) If you need specific number formatting, you can
replace each "General" here with whatever is appropriate.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
