Conditional Format

  • Thread starter Norman Kong via OfficeKB.com
  • Start date
N

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
 
R

Raj

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
 
N

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
 
R

Raj

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