Dsunil05
New Member
- Joined
- Feb 20, 2015
- Messages
- 34
- Office Version
- 2021
- 2019
- 2013
- 2007
- 2003 or older
- Platform
- Windows
12
<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
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