date & number

[Urraco]

Hello,
On the left I have some columns with dates formatted by days. how could I add the character ">" only for the days 1 to 11?
The solution must be a formula, because when I change the data on the left should be updated on the right...
Thank you very much!

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	from this						do this
2	20	21	22	23	24		20	21	22	23	24
3	25	26	27	28	29		25	26	27	28	29
4	30	31	1	2	3		30	31	1>	2>	3>
5	4	5	6	7	8		4>	5>	6>	7>	8>
6	9	10	11	12	13		9>	10>	11>	12	13
7	14	15	16	17	18		14	15	16	17	18
8	19	20	21	22	23		19	20	21	22	23
9	24	25	26	27	28		24	25	26	27	28
10	29	30	31	1	2		29	30	31	1>	2>
11	3	4	5	6	7		3>	4>	5>	6>	7>
12	8	9	10	11	12		8>	9>	10>	11>	12
13	13	14	15	16	17		13	14	15	16	17
14	18	19	20	21	22		18	19	20	21	22
15	23	24	25	26	27		23	24	25	26	27
16	28	1	2	3	4		28	1>	2>	3>	4>
17	5	6	7	8	9		5>	6>	7>	8>	9>
18	10	11	12	13	14		10>	11>	12	13	14
19	15	16	17	18	19		15	16	17	18	19
20	20	21	22	23	24		20	21	22	23	24
21	25	26	27	28	29		25	26	27	28	29
22	30	31	1	2	3		30	31	1>	2>	3>
23	4	5	6	7	8		4>	5>	6>	7>	8>
Sheet1

Cell Formulas
Range	Formula
B2:E23	B2	=A2+1
A3:A23	A3	=E2+1

 

[etaf]

=IF( A2 > 11, A2&">",a2)

Book2
	A	B	C	D	E	F	G	H	I
1
2	1	3						1	3
3	12							12>
Sheet2

Cell Formulas
Range	Formula
H2:I3	H2	=IF(A2="","",IF(A2>11,A2&">",A2))

 

[JamesCanale]

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	from this						do this
2	20	21	22	23	24		20	21	22	23	24
3	25	26	27	28	29		25	26	27	28	29
4	30	31	1	2	3		30	31	1>	2>	3>
5	4	5	6	7	8		4>	5>	6>	7>	8>
6	9	10	11	12	13		9>	10>	11>	12	13
7	14	15	16	17	18		14	15	16	17	18
8	19	20	21	22	23		19	20	21	22	23
9	24	25	26	27	28		24	25	26	27	28
10	29	30	31	1	2		29	30	31	1>	2>
11	3	4	5	6	7		3>	4>	5>	6>	7>
12	8	9	10	11	12		8>	9>	10>	11>	12
13	13	14	15	16	17		13	14	15	16	17
14	18	19	20	21	22		18	19	20	21	22
15	23	24	25	26	27		23	24	25	26	27
16	28	1	2	3	4		28	1>	2>	3>	4>
17	5	6	7	8	9		5>	6>	7>	8>	9>
18	10	11	12	13	14		10>	11>	12	13	14
19	15	16	17	18	19		15	16	17	18	19
20	20	21	22	23	24		20	21	22	23	24
21	25	26	27	28	29		25	26	27	28	29
22	30	31	1	2	3		30	31	1>	2>	3>
23	4	5	6	7	8		4>	5>	6>	7>	8>
Sheet1

Cell Formulas
Range	Formula
B2:E23	B2	=A2+1
G2:K23	G2	=IF(DAY(A2)<12,DAY(A2)&">",DAY(A2))
A3:A23	A3	=E2+1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G2:K23	Expression	=NOT(ISNUMBER(G2))	text	NO

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E
1
2	20	21	22	23	24
3	25	26	27	28	29
4	30	31	1>	2>	3>
5	4>	5>	6>	7>	8>
6	9>	10>	11>	12	13
7	14	15	16	17	18
8	19	20	21	22	23
9	24	25	26	27	28
10	29	30	31	1>	2>
11	3>	4>	5>	6>	7>
12	8>	9>	10>	11>	12
13	13	14	15	16	17
14	18	19	20	21	22
15	23	24	25	26	27
16	28	1>	2>	3>	4>
17	5>	6>	7>	8>	9>
18	10>	11>	12	13	14
19	15	16	17	18	19
20	20	21	22	23	24
21	25	26	27	28	29
22	30	31	1>	2>	3>
23	4>	5>	6>	7>	8>
Data

Cell Formulas
Range	Formula
B2:E23	B2	=A2+1
A3:A23	A3	=E2+1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:E23	Expression	=DAY(A2)<12	text	NO

With a custom cell format of d">"

 

[Urraco]

Thank you
Now I understand...