Conditional Format

[Norman Kong via OfficeKB.com]

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

 

[Guest]

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]

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

 

[Guest]

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..