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!

Oct 28, 2022 in Others 379 views

## 1 answer to this question.

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.

• 63,700 points

## How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

## How to install a GUI on Amazon AWS EC2 or EMR with the Amazon AMI

The top-level script for installing the GUI ...READ MORE

## How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

## Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

## Multiplying cells and sum then for a range

Use SUM() as an Array formula:  =SUM(IFERROR((AB22:AB1100 = ...READ MORE

## INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX(\$I\$2:\$I\$26,MATCH(V4,\$R\$2:\$R\$26,0))) The calculation ...READ MORE