Select B1 (or, if you actually want to have this functionality for any cell
in Column B, then select the entire column), click Format/Conditional
Formatting on Excel's menu bar, change the first drop down to "Formula Is"
and then copy/paste this into the blank field next to it...

=AND(B1=A1,B1<"")

Now, click the Format button, select the Patterns tab, pick a color from
color chart (I suggest pink rather than red as the text in the cell will be
more readable) and OK your way back to the work sheet. That's it... the cell
(or cells) should now react as you want them to.

--
Rick (MVP - Excel)


"Lewis" wrote in message
...
they are whole numbers ( 3, 6, 40 ) no decimal numbers

thnx for reply
:)



"Rick Rothstein" wrote in message
...
What type of "ordinary numbers"... are they integer (whole) numbers or
could are floating point numbers (those with a decimal point) possible as
well?

--
Rick (MVP - Excel)


"Lewis" wrote in message
...
Hi

I want to do the following..
i have A1 and B1 cells, and ordinary numbers inside, i want to compre
them so that when A1 = B1 nothing hapens but when they are not equal i
want to make B1 cell different colour (red)
i this possible to solve


thnx for reply
:)