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