Ongoing Conditional Formatting

[zacgc5]

Hello,

I have a situation where in a row, values starting from 1 and on get populated throughout the row (usually in order). What I would like to do is have some form of conditional formatting that will highlight a cell if the number is lower than any other cell to that cells left. I would want this to repeat as well as it goes down the row. Is this possible at all?

Example:

1

2

3

2

That 2 on the end would be highlighted since it's less than the 3.

Any help would be much appreciated.

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2	1	2	3	4	3	4	5	4	3	6
3	1	2	3	4	5	4	5	7	8	6
Result

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:J3	Expression	=COUNTIF($A2:A2,">"&B2)	text	NO

 

[etaf]

Edit, posted as i did , so you can ignore as solution provided

does this work for you

Select the range from B1 to ??
then use a formula

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	1	2	3	4	5	6	7	6	3	4	8	9
2
3		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	FALSE
Sheet1

Cell Formulas
Range	Formula
B3:L3	B3	=AND(B1<>"",MAX($A1:B1)>B1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:V15	Expression	=AND(B1<>"",MAX($A1:B1)>B1)	text	NO