Conditional Format
 

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

Do you mean integers and non-integers?

if so you can use conditional formatting with formulae of

=A2=INT(A2)

and

=A2<INT(A2)

--
HTH

Bob Phillips

"AWS" wrote in message
...
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

"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


"Bob Phillips" wrote:

Do you mean integers and non-integers?

if so you can use conditional formatting with formulae of

=A2=INT(A2)

and

=A2<INT(A2)

--
HTH

Bob Phillips

"AWS" wrote in message
...
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

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


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=470361

That did the trick

Thanks
_______________________________
AWS


"tkaplan" wrote:


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


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=470361