Cell format - fractions

[Matt]

I have a set of cells that show the fraction of #complete/#total. They
are formatted as fractions so that I can custom format them such that
those >=50% turn green and those <50% turn red. The problem is that
for a completion of say 8/10, excel automatically simplifies to 4/5.
Is is possible for excel to still recognize the cell as a fraction but
not simplify?

 

[Niek Otten]

Format Custom as ?/10

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a set of cells that show the fraction of #complete/#total. They
| are formatted as fractions so that I can custom format them such that
| those >=50% turn green and those <50% turn red. The problem is that
| for a completion of say 8/10, excel automatically simplifies to 4/5.
| Is is possible for excel to still recognize the cell as a fraction but
| not simplify?
|

 

[Matt]

8/10 was just an example. It could be 3/6 or 5/15. Is there a way to
do this for all fractions?
Thanks!

 

[Niek Otten]

<Is there a way to do this for all fractions?>

To do what? When does it have to be 3/6, not 6/12, when 5/15, not 1/3?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| 8/10 was just an example. It could be 3/6 or 5/15. Is there a way to
| do this for all fractions?
| Thanks!
|
|
| Niek Otten wrote:
| > Format Custom as ?/10
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > |I have a set of cells that show the fraction of #complete/#total. They
| > | are formatted as fractions so that I can custom format them such that
| > | those >=50% turn green and those <50% turn red. The problem is that
| > | for a completion of say 8/10, excel automatically simplifies to 4/5.
| > | Is is possible for excel to still recognize the cell as a fraction but
| > | not simplify?
| > |
|

 

[Matt]

I'm not sure I understand what you're asking. I want any fraction to
remain as is -- even if it is in unsimplified form.

 

[Niek Otten]

< I want any fraction to remain as is>

Do you mean that the fraction is not the result of a formula, but of manual input?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I'm not sure I understand what you're asking. I want any fraction to
| remain as is -- even if it is in unsimplified form.
|
|
| Niek Otten wrote:
| > <Is there a way to do this for all fractions?>
| >
| > To do what? When does it have to be 3/6, not 6/12, when 5/15, not 1/3?
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| >
| > | 8/10 was just an example. It could be 3/6 or 5/15. Is there a way to
| > | do this for all fractions?
| > | Thanks!
| > |
| > |
| > | Niek Otten wrote:
| > | > Format Custom as ?/10
| > | >
| > | > --
| > | > Kind regards,
| > | >
| > | > Niek Otten
| > | > Microsoft MVP - Excel
| > | >
| > | > |I have a set of cells that show the fraction of #complete/#total. They
| > | > | are formatted as fractions so that I can custom format them such that
| > | > | those >=50% turn green and those <50% turn red. The problem is that
| > | > | for a completion of say 8/10, excel automatically simplifies to 4/5.
| > | > | Is is possible for excel to still recognize the cell as a fraction but
| > | > | not simplify?
| > | > |
| > |
|

 

[Matt]

That is correct-- the fraction comes from manual input.

 

[Niek Otten]

Then you'll have to Custom format them with the denominator you need, like

?/15
?/6
?/12

etc

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| That is correct-- the fraction comes from manual input.
|

 

[Beege]

I have a set of cells that show the fraction of #complete/#total. They
are formatted as fractions so that I can custom format them such that
those >=50% turn green and those <50% turn red. The problem is that
for a completion of say 8/10, excel automatically simplifies to 4/5.
Is is possible for excel to still recognize the cell as a fraction but
not simplify?

Matt,

You could use =A1 & "/" & B1

but it would change to text, and Excel thinks its a date. But it would
look as you asked... Use conditional formatting to test the diviasion of
A1/B1.

beege

 

[SirMatthew]

Absolutely wonderful! I found just what I needed in less than a minute!
You're a genius!