Walter Hildebrandt wrote:
Cell A1 has a number.
Cell B1 is to have how much less, or much more, A1 is than 40.
When A1 is less than 40 the answer in B1 is to be in black.
When A1 is more than 40 the answer in B1 is to be in red.
.
This means if A1 is 50, the 10 in B1 is red. When A1 is 30, the -10 in B1
is black.
Walter:
Another option is just to create a new number format. The following
format code will turn the font red to anything equal to or greater than
0. Anything less than zero will be black.
[RED][>0]0;[BLACK]0
Search for 'number formats;codes' in the help file for more information
on user-defined number formats.
TomW
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
