How to manually piece together a fraction on excel

Question

I want to manually construct a fraction that could be read using conditional formatting while working with some tallies.

Following is the extracted formula that use fractional values:

COUNTIFS(Converter!40:40,"Y",Converter!$5:$5,F$5) & " / " & COUNTIFS(Converter!40:40,"Y",Converter!$5:$5,F$5) + COUNTIFS(Converter!40:40,"N",Converter!$5:$5,F$5)

Basically, the percentage should look like a/(a+b), and I want all tabulated digits, such 2/8 or 20/100, to be displayed when appropriate. Unfortunately, Excel is only seeing this as a date; even after using the TEXT() formula, Excel still interprets the digits as dates.

The conditional formatting should turn red for any number less than "1" if possible. How am I supposed to get Excel to read the numbers as fractions? It would be highly appreciated if you could help!

Answer 1

Instead of controlling formatting in your calculations, you should leave it up to how it appears visually.

You must first choose the cell that you want to format as a fraction.

Then you choose the desired fraction quantities.

Edit: You must use a custom format if you want to fix the denominator.