Conditional Format

A

AWS

I have cells with info like 1/6 and 2/2 etc

Is it possible to have a Conditional Format Formula that will color
cells with un-equal numbers (1/6, 3/4 etc) Red and
cells with equal numbers (3/3, 1/1 etc) Light Green

_______________________________
AWS
 
B

Bob Phillips

Do you mean integers and non-integers?

if so you can use conditional formatting with formulae of

=A2=INT(A2)

and

=A2<>INT(A2)
 
A

AWS

"1/3" represents "One of Three"
"2/2" represents "two of two" etc

I want the cells with the left hand number smaller than the right
to be shown in red, and if they match shown in green

_______________________________
AWS
 
T

tkaplan

in conditional formatting, put condition 1 formula is:
=RIGHT(A1,1)=LEFT(A1,1)
and format to green

condition 2 formula is:
=left(a1,1)>right(a1,1)
and format to red.

this assumes the data is in A1
 
Top