Highlight Unsorted Values

[joszepereira]

Hello.

[Intro]
I have a list of fuel supplies for various cars. In that list, it's registered the date, nr of liters, value(€), km, etc.
I use this data to analyse for example the average consumption, nr of km, etc.
Sometimes there are mistakes when introducing the km and then i have wrong analysis.

[Aim]
I thought that I could highlight all the unsorted values, for example:
CAR | km
A | 1
B | 5
A | 2
B | 3 - HIGHLIGHT
C | 9
C | 4 - HIGHLIGHT

Then, I would correct them.

The question is: how can I do this? OR can i make this in another easier way?

Thank you very much.
José

 

[Fluff]

Can you post a sample of your data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[joszepereira]

Can't use this Add-In because I'm using company laptop.

Here is the data:

DATE	CAR	LITERS	VALUE €	KM
20221201​	ABC	48,79​	78,55​	102271​
20221201​	ABC	45,33​	72,98​	1102626​		error 1 introducing data
20221201​	CDE	58,23​	93,75​	10599​
20221201​	CDE	50,03​	80,55​	11223​
20221201​	F	37,71​	60,72​	2813​
20221201​	RTR	53,38​	85,94​	31490​		error 2 introducing data
20221201​	SF	42,42​	68,3​	49826​
20221202​	RTR	55,43​	89,24​	20890​		highlight next one (error 2)
20221202​	VX	46,82​	75,38​	67271​
20221202​	ABC	61,14​	98,44​	102626​		highlight next one (error 1)

 

[Fluff]

Thanks for that.
How about

Fluff.xlsm
	A	B	C	D	E
1	DATE	CAR	LITERS	VALUE €	KM
2	20221201	ABC	48.79	78.55	102271
3	20221201	ABC	45.33	72.98	1102626
4	20221201	CDE	58.23	93.75	10599
5	20221201	CDE	50.03	80.55	11223
6	20221201	F	37.71	60.72	2813
7	20221201	RTR	53.38	85.94	31490
8	20221201	SF	42.42	68.3	49826
9	20221202	RTR	55.43	89.24	20890
10	20221202	VX	46.82	75.38	67271
11	20221202	ABC	61.14	98.44	102626
12
Data Input

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E2:E11	Expression	=INDEX(E$1:E1,XMATCH(B2,B$1:B1,0,-1))>E2	text	NO

 

[joszepereira]

Perfect! Thank you very much.
Didn't know the XMATCH function. Very useful.

Best regards.

 

[Fluff]

You're welcome & thanks for the feedback.