# Conditional Format Fractions

#### FWMYKIGI

##### New Member
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

### Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

#### sheetspread

##### Well-known Member
First format the cell(s) as text, then write an or() formula condition 3x

#### FWMYKIGI

##### New Member
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

##### Well-known Member
=OR(A1="1/2",A1="5/7",A1="10/25")

etc

#### FWMYKIGI

##### New Member

ADVERTISEMENT

=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

##### MrExcel MVP, Junior Admin
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:
Code:
``[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

##### New Member
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:
Code:
``[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

##### MrExcel MVP, Junior Admin
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!

Replies
3
Views
79
Replies
3
Views
217
Replies
3
Views
39
Replies
6
Views
78
Replies
20
Views
425

Threads
1,109,451
Messages
5,528,827
Members
409,839
Latest member
akashsadhu