need urgent help for excel

Copper Contributor

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

@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.

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