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
:)

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
:)

use conditional formatting

"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
:)

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
:)

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
:)

i already try it but i can't find right rule..

for instance i have
A B
1 1
1 2
2 2
3 1
2 2

i want highlighted B2 and B5

thnx for reply
:)

"Patrick Molloy" wrote in message
...
use conditional formatting

"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
:)

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
:)

The formula worked fine in my tests before I posted it, so I am guessing
that your local settings do not use the comma as a statement separator (I'm
only guessing here because I don't have any experience with international,
that is, non-US, versions of Excel)... perhaps yours statement separator is
a semi-colon (;) which is a separator symbol I've seen used in some
postings? I know it wouldn't be the colon that you tried because that would
make Excel look at the "A1:B1" part of the formula that would result from
that substitution as if it were a range.

--
Rick (MVP - Excel)


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

Use conditional formating with "Formula Is": =A1<B1 instead of =$A$1<$B$1.

Passo, Chad/Africa :)

"Lewis" a écrit dans le message de groupe de discussion :
...
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
:)

thanx a lot .. this is working!!!
Great job

thnx for reply
:)


"Passoret" wrote in message
...
Use conditional formating with "Formula Is": =A1<B1 instead of
=$A$1<$B$1.

Passo, Chad/Africa :)

"Lewis" a écrit dans le message de groupe de discussion
: ...
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
:)

i dot know.. i have office 2007.. but when i use ; nothing happens..
but Passo find the solution and it's working..
thanx for the effort..




thnx for reply
:)


"Rick Rothstein" wrote in message
...
The formula worked fine in my tests before I posted it, so I am guessing
that your local settings do not use the comma as a statement separator
(I'm only guessing here because I don't have any experience with
international, that is, non-US, versions of Excel)... perhaps yours
statement separator is a semi-colon (;) which is a separator symbol I've
seen used in some postings? I know it wouldn't be the colon that you tried
because that would make Excel look at the "A1:B1" part of the formula that
would result from that substitution as if it were a range.

--
Rick (MVP - Excel)