Find duplicate and Change cell & text color WITHOUT Conditional Formatting

[Dsunil05]

12	19	21	25	29	31	32	33	34	36	37	39	44	50	53	55	66	74	75	77
08	13	16	18	22	23	31	39	45	47	52	59	64	70	71	72	73	74	77	79
																			. . . . . . . . . . . . .
03	09	10	11	13	18	19	27	35	37	44	50	57	59	65	70	72	76	79	80
02	05	11	14	17	28	32	33	37	38	42	47	59	63	64	71	73	74	77	78
03	06	08	09	13	21	24	30	31	36	38	42	49	54	59	65	70	72	75	79

<tbody>
</tbody>

data range A1:T27
i want to find out same number And change their "cell color and text color" in data range A1:T26 of row no 27's 20 number in pink colour.
Without using Conditional Formatting
Because i copy it and use it to another data set in same worksheet e.g. range U1:AO27
In MS Excel 2007
Thanks

 

[Peter_SSs]

Duplicate to https://www.mrexcel.com/forum/excel-questions/1023740-find-same-value-changing-cell-tex-color-without-using-conditional-formatting.html#post4913039

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.