Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional to change cell color by Selecting Cells
It is possible to change the font color of the select cell only.
For example, If I select the cell A1 I want to see the font in blue, bold, however, after I select the cell A2 I want the cell A1 to return to its previous setup and get the blue, bold at cell A2. Therefore, the conditional will work only for selected cell if not select return to original setup. Thanks in advance. Maperalia |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional to change cell color by Selecting Cells
Try this:-
Right click the sheet tab and paste this in. Public LastCell As Range Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not LastCell Is Nothing Then LastCell.Interior.ColorIndex = xlNone End If Target.Interior.ColorIndex = 6 Set LastCell = Target End Sub Mike "maperalia" wrote: It is possible to change the font color of the select cell only. For example, If I select the cell A1 I want to see the font in blue, bold, however, after I select the cell A2 I want the cell A1 to return to its previous setup and get the blue, bold at cell A2. Therefore, the conditional will work only for selected cell if not select return to original setup. Thanks in advance. Maperalia |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional to change cell color by Selecting Cells
http://cjoint.com/?gwve7iDErM
-Select range A2:D16 -Format/MFC =And(Row()=Cell("row");Column()=Cell("column")) Private Sub Worksheet_SelectionChange(ByVal Target As Range) Calculate End Sub JB http://boisgontierjacques.free.fr/ On 22 juin, 20:00, maperalia wrote: It is possible to change the font color of the select cell only. For example, If I select the cell A1 I want to see the font in blue, bold, however, after I select the cell A2 I want the cell A1 to return to its previous setup and get the blue, bold at cell A2. Therefore, the conditional will work only for selected cell if not select return to original setup. Thanks in advance. Maperalia |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional to change cell color by Selecting Cells
Mike;
Thanks for the code works wonderful!!. However, I forgot to mention that the sheet where I want to put this conditional does not exist in the original "Template File". After I run a specific macro in the "Template File". The sheet where I want to put this conditional is been created and named it as a "LIST". Therefore, my question is; what statement can I use to insert the module on this sheet when I run the macro? Thanks. Maperalia. "Mike H" wrote: Try this:- Right click the sheet tab and paste this in. Public LastCell As Range Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not LastCell Is Nothing Then LastCell.Interior.ColorIndex = xlNone End If Target.Interior.ColorIndex = 6 Set LastCell = Target End Sub Mike "maperalia" wrote: It is possible to change the font color of the select cell only. For example, If I select the cell A1 I want to see the font in blue, bold, however, after I select the cell A2 I want the cell A1 to return to its previous setup and get the blue, bold at cell A2. Therefore, the conditional will work only for selected cell if not select return to original setup. Thanks in advance. Maperalia |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional to change cell color by Selecting Cells
JB;
Thanks for the formula. However, when I put it in the condition an then click OK I got the message that the formula has error. Maperalia "JB" wrote: http://cjoint.com/?gwve7iDErM -Select range A2:D16 -Format/MFC =And(Row()=Cell("row");Column()=Cell("column")) Private Sub Worksheet_SelectionChange(ByVal Target As Range) Calculate End Sub JB http://boisgontierjacques.free.fr/ On 22 juin, 20:00, maperalia wrote: It is possible to change the font color of the select cell only. For example, If I select the cell A1 I want to see the font in blue, bold, however, after I select the cell A2 I want the cell A1 to return to its previous setup and get the blue, bold at cell A2. Therefore, the conditional will work only for selected cell if not select return to original setup. Thanks in advance. Maperalia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying conditional formating to make cells change color | Excel Discussion (Misc queries) | |||
Conditional formating-change color of cells over than one with for | Excel Discussion (Misc queries) | |||
How can I change cell color using conditional formatting | Excel Discussion (Misc queries) | |||
Result of IF conditional change cell color | Excel Discussion (Misc queries) | |||
Conditional change to cell color | Excel Discussion (Misc queries) |