Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting in Excel
How do I highlight(change fill color) in one cell when text is entered in
another cell and not change the value of the cell I want highlighted? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting in Excel
Not sure if this is what you want but here's a little macro:
Sub MyHighlight() If Range("B1").Value "" Then Range("A1").Interior.ColorIndex = 6 ElseIf Range("B1").Value = "" Then Range("A1").Interior.ColorIndex = xlNone End If End Sub HHarold wrote: How do I highlight(change fill color) in one cell when text is entered in another cell and not change the value of the cell I want highlighted? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting in Excel
Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "A1" On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then If Target.Value < "" Then Me.Range("H1").Interior.ColorIndex = 38 Else Me.Range("H1").Interior.ColorIndex = xlColorIndexNone End If End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "HHarold" wrote in message ... How do I highlight(change fill color) in one cell when text is entered in another cell and not change the value of the cell I want highlighted? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting in Excel
Select B1 then......
FormatConditional FormattingFormula is: =A1<"" for anything at all in A1 =A1="string" for specific string. Format to a pattern you like. Gord Dibben MS Excel MVP On Thu, 7 Sep 2006 08:37:02 -0700, HHarold wrote: How do I highlight(change fill color) in one cell when text is entered in another cell and not change the value of the cell I want highlighted? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions | |||
Excel Open Dialog Improper Sort | Excel Discussion (Misc queries) | |||
Comparing worksheets in Excel and highlighting changes | Excel Worksheet Functions |