Conditional Format Fractions

FWMYKIGI

New Member
Joined
Mar 23, 2018
Messages
4
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
 

Some videos you may like

Excel Facts

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

FWMYKIGI

New Member
Joined
Mar 23, 2018
Messages
4

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")

RSIDHire DateHire AuthorityMY 17MY 16MY 15MY 14MY 13
1/35/917/1620/183/3
17/1716/140/00/36/5

<tbody>
</tbody>
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,508
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Mar 23, 2018
Messages
4
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
Joined
Aug 1, 2002
Messages
54,508
Office Version
  1. 365
Platform
  1. Windows
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!
 

Watch MrExcel Video

Forum statistics

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