Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cursor position to get colour
how will get colur in Cursor position only
for ex: my tex in B8, Cursor also in B8 then only B8 to be change difference colour, how it will work please help me Anshad |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cursor position to get colour
On Nov 29, 2:53 am, wrote:
how will get colur in Cursor position only for ex: my tex in B8, Cursor also in B8 then only B8 to be change difference colour, how it will work please help me Anshad Your question is not very clear, can you please give the example. Thanks AQIB RIZVI |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cursor position to get colour
On Nov 29, 2:19 pm, Aqib Rizvi wrote:
On Nov 29, 2:53 am, wrote: how will get colur in Cursor position only for ex: my tex in B8, Cursor also in B8 then only B8 to be change difference colour, how it will work please help me Anshad Your question is not very clear, can you please give the example. Thanks AQIB RIZVI Dear Aqib Rizvi My questine is in my worksheet as below: Name Cont no. Ahmed 8832875 fiaaz 9878532 Kareem 2354878 Anil 3395874 Vimal 9987582 Nippin 6698574 as like this but when the Cursor in cell that cell to highlight difference colour, it is possible, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cursor position to get colour
Place this macro in your sheet module. You can access that module by
right-clicking on the sheet tab and selecting View Code. Paste this macro into that module. "X" out of the module to return to your sheet. I chose the color red by setting the ColorIndex to 3. Change this as you wish. HTH Otto Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 3 End Sub wrote in message ... On Nov 29, 2:19 pm, Aqib Rizvi wrote: On Nov 29, 2:53 am, wrote: how will get colur in Cursor position only for ex: my tex in B8, Cursor also in B8 then only B8 to be change difference colour, how it will work please help me Anshad Your question is not very clear, can you please give the example. Thanks AQIB RIZVI Dear Aqib Rizvi My questine is in my worksheet as below: Name Cont no. Ahmed 8832875 fiaaz 9878532 Kareem 2354878 Anil 3395874 Vimal 9987582 Nippin 6698574 as like this but when the Cursor in cell that cell to highlight difference colour, it is possible, |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cursor position to get colour
hey otto.
can we also change the font color? "Otto Moehrbach" wrote in message ... Place this macro in your sheet module. You can access that module by right-clicking on the sheet tab and selecting View Code. Paste this macro into that module. "X" out of the module to return to your sheet. I chose the color red by setting the ColorIndex to 3. Change this as you wish. HTH Otto Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 3 End Sub wrote in message ... On Nov 29, 2:19 pm, Aqib Rizvi wrote: On Nov 29, 2:53 am, wrote: how will get colur in Cursor position only for ex: my tex in B8, Cursor also in B8 then only B8 to be change difference colour, how it will work please help me Anshad Your question is not very clear, can you please give the example. Thanks AQIB RIZVI Dear Aqib Rizvi My questine is in my worksheet as below: Name Cont no. Ahmed 8832875 fiaaz 9878532 Kareem 2354878 Anil 3395874 Vimal 9987582 Nippin 6698574 as like this but when the Cursor in cell that cell to highlight difference colour, it is possible, |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cursor position to get colour
Something like this perhaps: HTH Otto
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlNone Cells.Font.ColorIndex = 0 Target.Interior.ColorIndex = 3 Target.Font.ColorIndex = 43 End Sub "Gaurav" wrote in message ... hey otto. can we also change the font color? "Otto Moehrbach" wrote in message ... Place this macro in your sheet module. You can access that module by right-clicking on the sheet tab and selecting View Code. Paste this macro into that module. "X" out of the module to return to your sheet. I chose the color red by setting the ColorIndex to 3. Change this as you wish. HTH Otto Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 3 End Sub wrote in message ... On Nov 29, 2:19 pm, Aqib Rizvi wrote: On Nov 29, 2:53 am, wrote: how will get colur in Cursor position only for ex: my tex in B8, Cursor also in B8 then only B8 to be change difference colour, how it will work please help me Anshad Your question is not very clear, can you please give the example. Thanks AQIB RIZVI Dear Aqib Rizvi My questine is in my worksheet as below: Name Cont no. Ahmed 8832875 fiaaz 9878532 Kareem 2354878 Anil 3395874 Vimal 9987582 Nippin 6698574 as like this but when the Cursor in cell that cell to highlight difference colour, it is possible, |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cursor position to get colour
Note to OP
This code will wipe out any background color you may currently have in any cell or the worksheet, not just the activecell. If the wiping out part is not desirable I would suggest you use Chip Pearson's Rowliner Add-in which preserves original formatting whilst coloring the activecell. http://www.cpearson.com/excel/RowLiner.htm Gord Dibben MS Excel MVP On Thu, 29 Nov 2007 08:46:50 -0500, "Otto Moehrbach" wrote: Place this macro in your sheet module. You can access that module by right-clicking on the sheet tab and selecting View Code. Paste this macro into that module. "X" out of the module to return to your sheet. I chose the color red by setting the ColorIndex to 3. Change this as you wish. HTH Otto Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 3 End Sub wrote in message ... On Nov 29, 2:19 pm, Aqib Rizvi wrote: On Nov 29, 2:53 am, wrote: how will get colur in Cursor position only for ex: my tex in B8, Cursor also in B8 then only B8 to be change difference colour, how it will work please help me Anshad Your question is not very clear, can you please give the example. Thanks AQIB RIZVI Dear Aqib Rizvi My questine is in my worksheet as below: Name Cont no. Ahmed 8832875 fiaaz 9878532 Kareem 2354878 Anil 3395874 Vimal 9987582 Nippin 6698574 as like this but when the Cursor in cell that cell to highlight difference colour, it is possible, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return cursor to previous position | Excel Discussion (Misc queries) | |||
cursor position | Excel Discussion (Misc queries) | |||
Position Cursor to same address on another tab | Excel Worksheet Functions | |||
Cursor position | Excel Discussion (Misc queries) | |||
Cursor position? | Excel Discussion (Misc queries) |