Conditional Format Fractions

[FWMYKIGI]

How can I get conditional formatting to highlight cells with fractions. Is the only way to get this to separate each number them into different cells?

1/1, 2/2, 13/13 = green
1/2, 5/7, 10/25 = yellow
0/1, 0/8, 0/15 = red

 

[sheetspread]

First format the cell(s) as text, then write an or() formula condition 3x

 

[FWMYKIGI]

First format the cell(s) as text, then write an or() formula condition 3x

I'm sorry I'm not very advanced with excel, what formula should I use?

 

[sheetspread]

=OR(A1="1/2",A1="5/7",A1="10/25")

etc

 

[FWMYKIGI]

=OR(A1="1/2",A1="5/7",A1="10/25")

etc

Nothing is getting highlighted green when I input his formula for conditional formatting.. Here is what the table looks like. I pasted this formula =OR(A1="1/3",A1="3/3",A1="10/25")

RSID	Hire Date	Hire Authority	MY 17	MY 16	MY 15	MY 14	MY 13
			1/3	5/9	17/16	20/18	3/3
			17/17	16/14	0/0	0/3	6/5

<tbody>
</tbody>

 

[Joe4]

Nothing is getting highlighted green when I input his formula for conditional formatting.. Here is what the table looks like. I pasted this formula =OR(A1="1/3",A1="3/3",A1="10/25")

It doesn't look like any of those entries are in cell A1.

What you want to do is first select the ENTIRE range that you apply the Conditional Formatting to.
Then, write the formula as it pertains to the very FIRST cell in your selection. Excel will adjust it for the rest.

So change all those "A1" references to the address of the first cell in your selected range.
If you are selecting cells D2:H3, then write:

[COLOR=#333333]=OR([/COLOR][COLOR=#ff0000]D2[/COLOR][COLOR=#333333]="1/3",[/COLOR][COLOR=#ff0000]D2[/COLOR][COLOR=#333333]="3/3",[/COLOR][COLOR=#ff0000]D2[/COLOR][COLOR=#333333]="10/25")[/COLOR]

 

[FWMYKIGI]

It doesn't look like any of those entries are in cell A1.

What you want to do is first select the ENTIRE range that you apply the Conditional Formatting to.
Then, write the formula as it pertains to the very FIRST cell in your selection. Excel will adjust it for the rest.

So change all those "A1" references to the address of the first cell in your selected range.
If you are selecting cells D2:H3, then write:

[COLOR=#333333]=OR([/COLOR][COLOR=#ff0000]D2[/COLOR][COLOR=#333333]="1/3",[/COLOR][COLOR=#ff0000]D2[/COLOR][COLOR=#333333]="3/3",[/COLOR][COLOR=#ff0000]D2[/COLOR][COLOR=#333333]="10/25")[/COLOR]

For crying out loud, finally I got it. Thank you so much, I've been driving myself crazy for two days messing with formulas.

 

[Joe4]

You are welcome!

Yep, your formula needs to be "in synch" with the range you selected when you applied the formula. If it ever seems to be highlighting the wrong cells (or sometime none at all), this is very often the culprit!