Forum Discussion
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 then I want my original cell to display a letter, in this case D.
I can see how to do so with a colour but my basic knowledge defies me the letter.
If you have a specified interval (as 0-100) you can easily define each number what letter is linked to. If it's a free number, you should work with minimum (A or Z) and maximum (Z or A) and then work with proportions... but if it's something schoolish as votes, should be fine 0-100.
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.
It could be
=LOOKUP(A1,{0,0.5,0.7,0.85,0.95},{"","B","","M","GM"})or like
