Forum Discussion
David Paul Snelgar
Aug 20, 2018Copper Contributor
Conditional Formatting
A newby question I am sure but I would like to conditional format a cell to represent a letter not so much a colour. For example if a number in a neighbouring cell is between 0 and 50 for example the...
David Paul Snelgar
Aug 21, 2018Copper Contributor
Thanks, I'm still not sure though.
A little more info. The number I want to read from is a percentage. Each percentage needs to equal a letter, like a grade for example. So between 50 and 69 equates to B, between 85 and 95 equates to M and between 95 and 100 equates to GM.
If that helps explain any more.
SergeiBaklan
Aug 21, 2018Diamond Contributor
It could be
=LOOKUP(A1,{0,0.5,0.7,0.85,0.95},{"","B","","M","GM"})
or like