Home

need urgent help for excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1189930%22%20slang%3D%22en-US%22%3Eneed%20urgent%20help%20for%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1189930%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3EI%20need%20to%20make%20a%20school%20project.%3CBR%20%2F%3EI%20want%20to%20make%20a%20table%20of%20top%205%20programming%20languages%3CBR%20%2F%3Elike%20if%20that%20programming%20language%20is%20for%20web%20development%20or%20if%20it%20has%20more%20than%2050%25%2Cif%20its%20positive%20to%20turn%20into%20green%20if%20not%20into%20red.%3CBR%20%2F%3EThan%20to%20get%20all%20of%20that%20data%20and%20which%20row%2Fprogramming%20language%20has%20more%20positive%2Fgreen%20or%20negative%2Fred%20to%20show%3CBR%20%2F%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1189930%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1190082%22%20slang%3D%22en-US%22%3ERe%3A%20need%20urgent%20help%20for%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1190082%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F566274%22%20target%3D%22_blank%22%3E%40talikne610%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20this%20could%20be%20possible%2C%20small%20sample%20data%20with%20your%20desire%20result%20will%20allow%20us%20to%20give%20you%20correct%20solution%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%20Faraz%20Shaikh%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1190074%22%20slang%3D%22en-US%22%3ERe%3A%20need%20urgent%20help%20for%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1190074%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F566274%22%20target%3D%22_blank%22%3E%40talikne610%3C%2FA%3E%26nbsp%3BI%20assume%20that%20your%20project%20is%20about%20doing%20research%20and%20reporting%20you%20findings.%20Not%20necessarily%20learning%20(advanced)%20Excel.%20Consider%20to%20use%20an%20approach%20as%20demonstrated%20in%20the%20attached%20file.%3C%2FP%3E%3CP%3E1%3D%20yes%2C%200%3Dno%20and%20sum%20the%20scores%20for%20each%20functionality%20to%20rank%20the%20languages.%20Read%20more%20in%20the%20Excel%20help%20about%20%22Conditional%20Formatting%22%20to%20understand%20the%20automatic%20colouring%20of%20cells%2C%20based%20on%20their%20contents.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20go%20a%20bit%20more%20advanced%2C%20you%20could%20use%20scores%20from%2C%20for%20instance%2C%200%20(not%20capable)%20to%205%20(very%20capable)%2C%20and%20give%20each%20score%20it's%20own%20colour.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello,
I need to make a school project.
I want to make a table of top 5 programming languages
like if that programming language is for web development or if it has more than 50%,if its positive to turn into green if not into red.
Than to get all of that data and which row/programming language has more positive/green or negative/red to show
Thanks

2 Replies
Highlighted

@talikne610 I assume that your project is about doing research and reporting you findings. Not necessarily learning (advanced) Excel. Consider to use an approach as demonstrated in the attached file.

1= yes, 0=no and sum the scores for each functionality to rank the languages. Read more in the Excel help about "Conditional Formatting" to understand the automatic colouring of cells, based on their contents.

 

If you want to go a bit more advanced, you could use scores from, for instance, 0 (not capable) to 5 (very capable), and give each score it's own colour.

Highlighted

Hi @talikne610 

 

Yes this could be possible, small sample data with your desire result will allow us to give you correct solution

 

Regards, Faraz Shaikh 

Related Conversations
Getting the previous spill range of a dynamic array function
pyxll in Excel on
0 Replies
Summarising Pivot Tables
jasonm69 in Excel on
0 Replies
Issue with Power Query and Access database
MCL0001 in Excel on
0 Replies
Timezone now function office 365
Jhnijman in Excel on
4 Replies
Pivot table with percentage calculation
aditya1986 in Excel on
1 Replies
Compare Names on a List
Marcus2555 in Excel on
1 Replies