Forum Discussion
Solved
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*...
Nope, in custom number formatting you may apply up to two conditions, not more. Alternatively you may use conditional formatting, something like
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.