How to show increase in trend numbers, possibly conditional formatting?

[winds]

Hello. I would like to have a function where Excel can show from column M, P, S and V shows that there is an increase in numbers. For example, in row 1 the numbers respectively are 25, 50, 60 and 80 so Excel will show (or highlight) this trend. However, another row will show example 50, 60, 40 and 30 so it will not highlight. So the trend must always be consistently increasing... any ideas?

 

[awoohaw]

does this work?

WorkBook1.xlsx
	F	G	H	I	J	K
2
3
4	25	50	60	80
5	50	60	40	60
6	2	3	5	8
7
8
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F6:I6	Expression	=AND($F$4<$G$4,$G$4<$H$4,$H$4<$I$4)	text	NO
F6:I6	Expression	=AND(F6<G6,G6<H6,H6<I6)	text	NO
F4:I4	Expression	=AND($F$4<$G$4,$G$4<$H$4,$H$4<$I$4)	text	NO
F4:I4	Expression	=AND(F4<G4,G4<H4,H4<I4)	text	NO

 

[awoohaw]

I tried to fix my errors in the above, this may be better:

WorkBook1.xlsx
	E	F	G	H	I	J
2
3
4		25	50	60	80
5		50	60	40	60
6		2	3	5	8
7
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F4:I6	Expression	=AND($F4<$G4,$G4<$H4,$H4<$I4)	text	NO

 

[winds]

Not quite I think. This works as the columns are next to each other, but for my case the columns are apart, specifically column M, P, S and V

 

[awoohaw]

Not quite I think. This works as the columns are next to each other, but for my case the columns are apart, specifically column M, P, S and V

WorkBook1.xlsx
	L	M	N	O	P	Q	R	S	T	U	V	W
3
4		25			50			60			80
5		50			60			40			60
6		2			3			5			8
7
8
9		1			2			3			4
10		5			6			5			1
11		6			7			8			9
12
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
V4:V6,S4:S6,P4:P6,M4:M6,M9:M11,P9:P11,S9:S11,V9:V11	Expression	=AND($M4<$P4,$P4<$S4,$S4<$V4)	text	NO

 

[winds]

Thank you!

 

[awoohaw]

@winds, if one of the threads has a solution that works for you please mark it as being answered.

 

[winds]

@winds, if one of the threads has a solution that works for you please mark it as being answered.

Ok done thank you!