i've try it but it does not work .. formula contains an errorr.. and when i
try swich , with : it just colours whole row...


thnx for reply
:)



"Rick Rothstein" wrote in message
...
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
:)