I want my numbers in my excel spreadsheet to be one color if above a certain number, and another if they're below. I've been trying to figure it out with the if function but can't make it work. Any ideas?
2006-09-07 02:56:45 · 7 answers · asked by Anonymous in Computers & Internet ➔ Software
WHY DO PEOPLE ANSWER WHEN THEY HAVE NO IDEA?
WHY DO PEOPLE ANSWER WHEN THEY HAVE NO IDEA?
WHY DO PEOPLE ANSWER WHEN THEY HAVE NO IDEA?
WHY DO PEOPLE ANSWER WHEN THEY HAVE NO IDEA?
WHY DO PEOPLE ANSWER WHEN THEY HAVE NO IDEA?
WHY DO PEOPLE ANSWER WHEN THEY HAVE NO IDEA?
(Excluded are all the people that mentioned Conditional Formating)
2006-09-07 03:02:37 · answer #1 · answered by f 3 · 1⤊ 1⤋
Format the cells with conditional formatting:
Select the cell and go to Format->Conditional Formatting.
Let's say you want the numbers below 0 to be in red, just select the appropriate things in the boxes so that it reads "Cell value is less than 0". Then click the format button and change the font to red. Click OK and you're done.
2006-09-08 12:45:52 · answer #2 · answered by Lewiy 3 · 0⤊ 0⤋
Use conditional formatting.
FORMAT - Conditional Formatting
You can set the color for values between 1 and 100 to blue and 101 to 200 to red etc.
Have Fun!
2006-09-07 09:59:50 · answer #3 · answered by eeaglenest 3 · 1⤊ 0⤋
In excel press F1 and search for "conditional formatting" or check out this tutorial
http://www.mvps.org/dmcritchie/excel/condfmt.htm
all the best
2006-09-07 10:05:05 · answer #4 · answered by Anonymous · 0⤊ 0⤋
Piece of cake.. called Conditional Formatting under the Format menu. Email me if you need more help
2006-09-07 09:59:49 · answer #5 · answered by Wonder world 2 · 3⤊ 0⤋
hi..
feel free to call me at (636)-486-4086
i can help u on this riteaway online.
Do you use a lot of excel ? Do you want to be an excel expert ? i can teach u advanced excel online.
Regards,
Sami
2006-09-07 14:32:38 · answer #6 · answered by sam e 2 · 0⤊ 1⤋
there isn't such a thing I think
2006-09-07 09:58:54 · answer #7 · answered by gggnm 3 · 0⤊ 4⤋