Hi,
I would like to kindly ask for code for the following situation:
I have results (calculated by formula) for a number of people in one column. The top 20% of the results are red colored cells and the bottom 20% of the results are blue colored cells, the cells of the remaining 60% of the results are not colored. I applied conditional formatting to color the top 20% and the bottom 20% of the cells. I need to determine a percentage for each of the cells in question, and I think I need a user defined function, where:
If the reference cell is red, result in next column is 15%
If the reference cell is blue, result in next column is 5%
If the reference cell is not colored, result in next column is 10%
Thank you very much in advance!
I would like to kindly ask for code for the following situation:
I have results (calculated by formula) for a number of people in one column. The top 20% of the results are red colored cells and the bottom 20% of the results are blue colored cells, the cells of the remaining 60% of the results are not colored. I applied conditional formatting to color the top 20% and the bottom 20% of the cells. I need to determine a percentage for each of the cells in question, and I think I need a user defined function, where:
If the reference cell is red, result in next column is 15%
If the reference cell is blue, result in next column is 5%
If the reference cell is not colored, result in next column is 10%
Thank you very much in advance!