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

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