Change formatting if value does not equal the previous columns value?

[max3732]

I am importing data from a pdf into excel 2007 that contains numbers for different groups going across horizontally in different columns.

Is there a way to select the data and then use conditional formatting to highlight if the value does not equal the one to its left? For example:

Bob 25 25 25 25 38 38 38 38 38
Jan 10 10 10 10 10 10 10 10 87 87

Is there a way to highlight the first 38 for Bob and the 1st 87 for Jan?

[carrob]

Highlight all your data but exclude the first column of numbers, and use this formula for conditional formatting:

=NOT(C1=OFFSET(C1,0,-1))

This assumes bob is in cell A1 and the data begins at B1

Let me know if this works for you.

[wfm007]

Yes....example put conditional formatting for Bob on second 25 as below:

1.) Go to Conditional Formatting through Home

2.) Then click on New Rule

3.) Then click on "Format only cells that contain"

4.) Then change "between" to "not equal to"

5.) Then in box right next to it put first 25 address like B2 or C2 as per data but make sure you remove $ sign from it.

6.) Then click on format & set as per requirement

7.) Then click on "Ok" & again click on "Ok" to exit

[protonLeah]

Use Conditional Formatting with =C1<>B1