Hello,
I am trying to help my wife with a school data table. She wants to conditionally format the boxes within the table to color code them, the problem is that she wants the data set displayed as a fraction, which is only difficult because there are some kids that have 0/7 correct or 7/7 correct which do not format well when using number formatting. Any ideas?
![](/board/proxy.php?image=http%3A%2F%2Fi20.photobucket.com%2Falbums%2Fb244%2Fjiggidyj%2FExcelQuestion_zps0bd0f345.jpg&hash=3b8bb3374484420318ef3fed27041248)
I am trying to help my wife with a school data table. She wants to conditionally format the boxes within the table to color code them, the problem is that she wants the data set displayed as a fraction, which is only difficult because there are some kids that have 0/7 correct or 7/7 correct which do not format well when using number formatting. Any ideas?
![](/board/proxy.php?image=http%3A%2F%2Fi20.photobucket.com%2Falbums%2Fb244%2Fjiggidyj%2FExcelQuestion_zps0bd0f345.jpg&hash=3b8bb3374484420318ef3fed27041248)