How do I solve these problems in Excel? I have a classroom of Math students. I want to insert into a cell the number of correct and convert into a percentage,

Problem #1 ‘Example’
John correct 25 25/35 cell to read 62.8%
Jane correct 32 32/35 cell to read 91.4%
Ralph correct 29 29/35 cell to read 82.8%

Problem #2 Conditional Formatting
Format only cells that contain
Blanks
Format with ‘Color’

After a value for John, Jane or Ralph is inserted the format ‘Color’ will be ‘no fill’

Richard@daysman.com