Different color for next cell with different value

I need to quickly and accurately find the next item that is a different value. Essentially, is there a way for me to automatically turn my first screenshot into my second one?

Workbook1.png

Workbook2.png

Hi, welcome to the forum

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

Having said that, it sounds like you needf to use Conditional Formatting.

1. highlight the range you want to apply the conditional formatting to (start 1 row below where your data starts - say, A2)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$A2<>$A1 formay fill your color choice

no, it will compare A1-A2, then A2-A3, then A3-A4 etc