Forum Discussion
Formating numbers to appear as text
Recently ive been ,aking an excel sheet of my grades, and now i want to create a chart based off of it, so that when i type 7 its written as A*, 6 will be A and so on. ive tried this formula [=7]"A*";[=6]"A";[=5]"B";[=4]"C";[=3]"D";[=2]"E";[=1]"U";General and this one [=7]"A*";[=6]"A";[=5]"B";[=4]"C";[=3]"D";[=2]"E";[=1]"U" but i get errors. however when i just type [=7]"A*";[=6]"A" it works but no more than that, is there any way to fix this without having to create a helper column?
Nope, in custom number formatting you may apply up to two conditions, not more. Alternatively you may use conditional formatting, something like
3 Replies
this is what id ended up using with the added benefit of being able to select colors for each one
Exactly, you may format both cells and values.
Nope, in custom number formatting you may apply up to two conditions, not more. Alternatively you may use conditional formatting, something like
