Highlight 3 diagonals

[Kishan]

Using Excel 2000

Hi,

I need to highlights 3 diagonals weather are they numbers or alphabets

In the example below check first column C to find diagonal in the column D & E

For example C6 is empty go for C7 if C7 is empty go for C8, Yes find diagonal in C8, D9 & in E10 (in this case as in the row 8 find Diagonal check the complete row C8:P8 and highlight all diagonal) as found one more in the row 8 in cells M8, N10 & in O10 and continue same method to find all possible diagonal

Example data with numbers...

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2
3
4
5		ROW N	C1	C2	C3	C4	C5	C6	C7	C8	C9	C10	C11	C12	C13	C14
6		6					5		5	5
7		7					5	5				5	5
8		8	5	5	5	5			5			5	5		5
9		9		5	5	5			5				5	5	5	5
10		10			5			5		5	5	5	5		5
11		11	5				5			5	5
12		12	5	5		5	5				5
13		13	5		5	5				5	5	5	5	5
14		14			5	5					5		5
15		15		5		5	5		5			5		5	5	5
16		16	5	5		5	5				5	5		5	5
17		17		5			5			5					5
18		18		5	5	5					5					5
19		19	5		5		5		5	5	5	5		5		5
20		20			5			5		5		5			5	5
21		21	5	5	5				5	5	5	5		5	5
22		22	5	5		5		5		5		5			5
23		23	5	5	5				5		5				5	5
24		24		5	5	5	5	5	5	5	5	5		5		5
25		25		5	5				5	5		5
26		26		5				5				5	5	5		5
27		27	5		5	5		5							5
28		28	5	5	5			5	5		5	5		5		5
29		29		5				5	5	5	5	5	5		5
30		30				5	5		5	5			5
31		31	5	5	5			5			5		5			5
32		32			5			5	5	5
33		33				5	5				5	5	5
34		34	5				5			5	5		5	5	5
35		35	5		5			5	5			5		5	5	5
36		36	5		5		5	5		5		5		5	5
37		37				5	5	5	5	5	5	5	5	5	5
38		38	5	5		5			5	5			5	5	5
39		39	5	5	5	5				5						5
40		40		5			5	5		5						5
41		41	5	5	5	5				5		5		5		5
42		42	5						5		5		5	5		5
43		43		5		5	5	5	5		5	5		5
44		44	5	5			5	5	5	5	5		5	5		5
45		45		5					5		5					5
46		46	5	5	5			5			5	5		5
47		47	5		5		5	5	5		5	5	5	5		5
48		48	5		5		5	5			5			5
49		49		5	5	5		5					5
50		50			5	5			5		5	5
51		51		5	5		5	5	5	5		5		5	5	5
52		52					5		5				5			5
53		53	5	5		5		5	5		5	5	5			5
54		54		5			5	5				5		5	5	5
55		55					5	5					5	5	5
56		56	5	5						5	5	5	5	5		5
57		57		5	5			5	5			5		5	5
58		58		5	5			5					5	5		5
59		59	5			5				5		5
60		60				5		5		5	5	5	5	5
61		61	5					5		5		5
62		62	5	5		5	5		5	5	5	5	5	5		5
63		63		5	5					5			5	5	5
64		64		5	5	5		5			5		5
65		65	5		5					5	5	5	5	5	5
66		66						5	5	5	5		5	5	5
67		67		5	5		5		5	5			5		5
68		68		5								5			5
69		69		5		5	5				5				5
70		70	5			5	5	5				5				5
71		71		5				5		5	5	5
72		72				5	5	5		5	5	5
73		73	5	5	5					5	5					5
74		74	5		5	5		5		5				5
75		75	5	5		5	5		5				5	5	5
76		76			5		5			5		5		5		5
77		77						5				5
78		78		5						5			5
79		79
80		80
Sheet1

Example data with alphabets...

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2
3
4
5		ROW N	C1	C2	C3	C4	C5	C6	C7	C8	C9	C10	C11	C12	C13	C14
6		6					A		A	A
7		7					A	A				A	A
8		8	A	A	A	A			A			A	A		A
9		9		A	A	A			A				A	A	A	A
10		10			A			A		A	A	A	A		A
11		11	A				A			A	A
12		12	A	A		A	A				A
13		13	A		A	A				A	A	A	A	A
14		14			A	A					A		A
15		15		A		A	A		A			A		A	A	A
16		16	A	A		A	A				A	A		A	A
17		17		A			A			A					A
18		18		A	A	A					A					A
19		19	A		A		A		A	A	A	A		A		A
20		20			A			A		A		A			A	A
21		21	A	A	A				A	A	A	A		A	A
22		22	A	A		A		A		A		A			A
23		23	A	A	A				A		A				A	A
24		24		A	A	A	A	A	A	A	A	A		A		A
25		25		A	A				A	A		A
26		26		A				A				A	A	A		A
27		27	A		A	A		A							A
28		28	A	A	A			A	A		A	A		A		A
29		29		A				A	A	A	A	A	A		A
30		30				A	A		A	A			A
31		31	A	A	A			A			A		A			A
32		32			A			A	A	A
33		33				A	A				A	A	A
34		34	A				A			A	A		A	A	A
35		35	A		A			A	A			A		A	A	A
36		36	A		A		A	A		A		A		A	A
37		37				A	A	A	A	A	A	A	A	A	A
38		38	A	A		A			A	A			A	A	A
39		39	A	A	A	A				A						A
40		40		A			A	A		A						A
41		41	A	A	A	A				A		A		A		A
42		42	A						A		A		A	A		A
43		43		A		A	A	A	A		A	A		A
44		44	A	A			A	A	A	A	A		A	A		A
45		45		A					A		A					A
46		46	A	A	A			A			A	A		A
47		47	A		A		A	A	A		A	A	A	A		A
48		48	A		A		A	A			A			A
49		49		A	A	A		A					A
50		50			A	A			A		A	A
51		51		A	A		A	A	A	A		A		A	A	A
52		52					A		A				A			A
53		53	A	A		A		A	A		A	A	A			A
54		54		A			A	A				A		A	A	A
55		55					A	A					A	A	A
56		56	A	A						A	A	A	A	A		A
57		57		A	A			A	A			A		A	A
58		58		A	A			A					A	A		A
59		59	A			A				A		A
60		60				A		A		A	A	A	A	A
61		61	A					A		A		A
62		62	A	A		A	A		A	A	A	A	A	A		A
63		63		A	A					A			A	A	A
64		64		A	A	A		A			A		A
65		65	A		A					A	A	A	A	A	A
66		66						A	A	A	A		A	A	A
67		67		A	A		A		A	A			A		A
68		68		A								A			A
69		69		A		A	A				A				A
70		70	A			A	A	A				A				A
71		71		A				A		A	A	A
72		72				A	A	A		A	A	A
73		73	A	A	A					A	A					A
74		74	A		A	A		A		A				A
75		75	A	A		A	A		A				A	A	A
76		76			A		A			A		A		A		A
77		77						A				A
78		78		A						A			A
79		79
80		80
Sheet2

Thank you in advance

Kishan

 

[Rick Rothstein]

Hi Rick Rothstein, Ok I got it how to execute the line code " Len(Range("G8").Value)" in the VBA editor's Immediate Window pointing mouse on the code line I can see this (Range ("G8").Value = "")
I run the new code from the post# 29 no luck it is resulting as shown in the post#26

It is very hard to diagnose program from afar. Can you send me a copy of your workbook with the raw data before you do anything to it so that I can watch my code run against your actual data in order to be able to debug it live? My email address is...

rick DOT news AT verizon DOT net