| Blogs > Sm3agol |
|
Sm3agol
United States2055 Posts
Basically I have | Name | ID# | Department | yes/no answer | score | score | score | about 700 rows long. Is there a way to set it so that a number less than X would make the cell a different color, and an answer of no, for example, would make that cell a different color? Excel n00b here. I I've tried googling some stuff, but I'm not sure what to even look for.   | ||
|
TheToast
United States4808 Posts
| ||
|
ComaDose
Canada10357 Posts
grab all the cells above the break off and highlight them a colour. your only talking 700 cells and something like ten score columns? then you can sort by name or id number again. if you need to preserve the order it is in now then you can add a new column to number it (even temporarily) edit: clarity | ||
|
MisterD
Germany1338 Posts
| ||
|
Sm3agol
United States2055 Posts
| ||
|
Melchior
United States112 Posts
| ||
|
Sm3agol
United States2055 Posts
Edit: never mind on the bolded part, I'm just retarded. | ||
|
BrTarolg
United Kingdom3574 Posts
On January 10 2012 03:56 Sm3agol wrote: I'm doing an Excel database sheet that involves names scores and yes/no cells. Basically I have | Name | ID# | Department | yes/no answer | score | score | score | about 700 rows long. Is there a way to set it so that a number less than X would make the cell a different color, and an answer of no, for example, would make that cell a different color? Excel n00b here. I I've tried googling some stuff, but I'm not sure what to even look for. Yes I could write a macro for you, but youd have to pay me | ||
|
jdsowa
405 Posts
1. Go to the "Score" column that you want to color code and highlight all of the entries. 2. Go up to "Format" in your menu, and then pick "Conditional Formatting". 3. Make it say "Cell Value Is Less Than 700" and then click on the format button, choose the "patterns" tab and pick the color that you want the low scores to be. 4. Then click the "Add >>" button so you can add a second condition. And make that one be "More Than 699" and color it accordingly. Edit: note that this build order is pretty all-in, if you do not do significant economic damage you will be very far behind. | ||
|
TiTanIum_
Brazil1335 Posts
On January 10 2012 04:50 jdsowa wrote: No need for a macro. 1. Go to the "Score" column that you want to color code and highlight all of the entries. 2. Go up to "Format" in your menu, and then pick "Conditional Formatting". 3. Make it say "Cell Value Is Less Than 700" and then click on the format button, choose the "patterns" tab and pick the color that you want the low scores to be. 4. Then click the "Add >>" button so you can add a second condition. And make that one be "More Than 699" and color it accordingly. Edit: note that this build order is pretty all-in, if you do not do significant economic damage you will be very far behind. I find it easier to make a UDF... | ||
|
TiTanIum_
Brazil1335 Posts
| ||
Chill
Calgary25981 Posts
| ||
|
Sm3agol
United States2055 Posts
On January 10 2012 05:08 Chill wrote: Ya, conditional formatting will own this. This man speaks the truth, and is exactly what I was looking for. Thanks. | ||
|
EatThePath
United States3943 Posts
| ||
|
how
United States538 Posts
| ||
|
shublar
Korea (South)264 Posts
| ||
| ||
StarCraft 2 StarCraft: Brood War Dota 2 Counter-Strike Super Smash Bros Other Games summit1g6149 Grubby2271 shahzam847 ViBE209 Pyrionflax153 C9.Mang080 Maynarde72 JuggernautJason58 ZombieGrub44 ToD3 |
|
PiGosaur Monday
Afreeca Starleague
hero vs Alone
Royal vs Barracks
Replay Cast
The PondCast
WardiTV Summer Champion…
Replay Cast
LiuLi Cup
MaxPax vs TriGGeR
ByuN vs herO
Cure vs Rogue
Classic vs HeRoMaRinE
Cosmonarchy
OyAji vs Sziky
Sziky vs WolFix
WolFix vs OyAji
BSL Team Wars
Team Hawk vs Team Dewalt
BSL Team Wars
Team Hawk vs Team Bonyth
[ Show More ] |
|
|
EPT
