I have a range of values against client data and a set of totals at the top of the sheet showing new codes introduced and with the client matched codes.
I used the conditional formatting feature elsewhere which doesnt work here. How can I make the cell in the client various shades dependant on its value against the total codes for that group?
total new codes jan: 692
abi new codes match overall 485
would like b16 and subsequent cells to have different colour the least matched the deeper the red going to green for most matched
not sure how to do that