Hi,
I don't know if this is possible but please see my screenshot below of an example I've created.
I want the cell in B2 to return the % of all the cells from C2:X2 that are the green colour, these cells are green as a result of conditional formatting in the vlookup table. So B2 should return 16.66% as 3/18 of the cells are green. And B3 would return 50% as half the cells are green. Is there some formula I can use to count cells of a certain colour?
Thanks,
Andy
I don't know if this is possible but please see my screenshot below of an example I've created.
I want the cell in B2 to return the % of all the cells from C2:X2 that are the green colour, these cells are green as a result of conditional formatting in the vlookup table. So B2 should return 16.66% as 3/18 of the cells are green. And B3 would return 50% as half the cells are green. Is there some formula I can use to count cells of a certain colour?
Thanks,
Andy