Conditional Format-struggling way

Hi ..

Can someone help please ... struggling

I need conditional format formula which allows me set a colour to the row
on if the cell value in a colume is not the same as the previous cell in
that same colume.
example :-
row 10 col 2 contains 200 no colour change
row 11 col 2 contains 200 no colour change
row 12 col 2 contains 300 change colour of this row to say red
row 13 col 2 contains 300 no colour change
row 14 col 2 contains 300 no colour change
row 15 col 2 contains 325 change colour of this row to red
Thanking you in advance
regards
Norman

--
Message posted via http://www.officekb.com

While in B11, go (in the menubar) to Format --> Conditional Formatting.
The first box should be on 'Cell Value Is',
the second on 'not equal to' and
the third on =B10 (make sure there are no dollarsigns in the formula)
then click Format and make the pattern red or whatever you want and close with OK.
Then, copy the format of B11 to the other cells and voila, every changed value is red.

Hi Norman

Suppose you want to evaluate this condition in B column. Select B2 Go to
Format -> Conditional Formatting. Select formula is and try this formula.
=$B2<>$B1.
Click Ok and copy the cell and paste the format in the entire sheet (using
paste special). The formulae works.

I hope this solves your problem
Take Care
Raj

"Norman Kong via OfficeKB.com" wrote:

> Hi ..
>
> Can someone help please ... struggling
>
> I need conditional format formula which allows me set a colour to the row
> on if the cell value in a colume is not the same as the previous cell in
> that same colume.
> example :-
> row 10 col 2 contains 200 no colour change
> row 11 col 2 contains 200 no colour change
> row 12 col 2 contains 300 change colour of this row to say red
> row 13 col 2 contains 300 no colour change
> row 14 col 2 contains 300 no colour change
> row 15 col 2 contains 325 change colour of this row to red
> Thanking you in advance
> regards
> Norman
>
> --
> Message posted via http://www.officekb.com
>

Thanks Raj much appreciated ....it works!!

Do you know of a way to then set the conditional format for the specific
columns, ie can I set the colour red across certain columes within that row.

Regards
Norman

--
Message posted via http://www.officekb.com

Its simple. Don't paste the format in the entire worksheet but paste the
format only in the coumns where you want it to get highlighted..

"Norman Kong via OfficeKB.com" wrote:

> Thanks Raj much appreciated ....it works!!
>
> Do you know of a way to then set the conditional format for the specific
> columns, ie can I set the colour red across certain columes within that row.
>
> Regards
> Norman
>
> --
> Message posted via http://www.officekb.com
>