How to solve this?

  • Thread starter Thread starter Lewis
  • Start date Start date
L

Lewis

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?
 
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.
 
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
:)
 
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
:)
 
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.
 
Use conditional formating with "Formula Is": =A1<>B1 instead of =$A$1<>$B$1.

Passo, Chad/Africa :)
 
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
:)
 
Back
Top