I'm trying to create a grade sheet where it will flag number grades in a certain range by turning that row another color.
The problem I'm having has to do with grades of Zero. I have this formula for the other grades, with 90% being the passing mark, so anything above that isn't marked
The problem is that apparently the value of an empty cell is considered to be 0 by the spreadsheet. If I did a conditional format with the following:
the spreadsheet lights up.