Conditional formatting

[Dhudson]

So what I'm trying to do is for example

The information in D, E and F column are fixed.

but the colour of the number is conditional to the DEF column so

• G is conditional to D
  • G4 to D4
  • G5 to D5 etc
• H is conditional to E
• I is conditional to F

If it is higher than the previous number then the box turns red and if it is lower it turns green. This bit I have worked out

Is there a quick way to format the entire table or does it have to be conditioned for each cell? There’s over 3000 cells to format.

Is there no way to copy the layout of the entire format and move its position across to the right one or to cells below

 

[Dhudson]

It won’t let me upload the image’s actual size

Entire range

 

[Fluff]

In that case it should work

Fluff.xlsm
	D	E	F	G	H	I
1
2	72	45	46	37	10	90
3	50	4	17	33	6	28
4	96	19	1	96	87	22
5	9	64	12	81	58	90
6	50	43	6	94	62	25
7	20	98	25	17	26	81
8	14	3	92	30	63	37
9	60	54	47	2	49	60
10	17	30	87	93	19	67
11	61	22	84	24	81	77
Data

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G2:I11	Expression	=G2>D2	text	NO
G2:I11	Expression	=G2<D2	text	NO