View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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