Walter,
If you are trying to duplicate your original request in subsequent rows,
see below:
Walter Hildebrandt wrote:
I created a test spreadsheet and put 50 in cell A1, 30 in cell A2, and 40 in
cell A3. Putting the formula
A1-40+IF(A1>40;STYLE("RedText");0)
in cell B1. I then copied B1 to B2 and to B3.
You do not need a formula. Just enter (for Row 1) A1-40 in Cell B1. For
Row 2 you must enter A2-40 in Cell B2, etc. Copying will not work.
The correct numbers are in B1, B2, and B3. B1 is 10, B2 is -10 and B3 is
0. *The problem is that all the B cells have red numbers.* I have probably
not crated the correct RedText style
When creating the RedText style, I clicked on the “Font Effects” tab > In
the “Font color” pull-down menu I selected *Red* > I click *OK*. How do I
get the minus numbers, such as the -10 in B2, to be black instead of red?
This is where conditional formatting comes in, as I described in an
earlier post.
Now select cell B1 (or B2, etc.) and from the menu bar select Format >
Conditional Formatting ; Put a check in condition 1; in the drop down
boxes select "cell value is"; "greater than or equal to"; in the next
box enter 0 (zero); Select Cell Style "RedText" Select OK. That will work.
You must set the conditional formatting individually for each cell you
want it to apply to. I just verified the above and it works perfectly
2009/11/7 Johnny Rosenberg <[email protected]>:
2009/11/6 Walter Hildebrandt <[email protected]>:
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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
