+ Reply to Thread
Results 1 to 2 of 2

highlight selection cell that meets criteria and multiple cells if not

  1. #1
    Registered User
    Join Date
    03-30-2011
    Location
    Manila, Phils
    MS-Off Ver
    Excel 2003
    Posts
    2

    highlight selection cell that meets criteria and multiple cells if not

    hello,

    I can't seem to incorporate a code to highlight multiple*adjacent cells if they are blank.
    Scenario:
    I have 3 column E (Yes), F (No)*and G (Na),*one of cell is*tagged as "x"
    All No and Na*with x are highlighted in red.
    If none of the three selection is marked "x", highlight 3 cells*in blue.

    I have the code below:

    Sub Highlight ()
    With WS.Range("$F:$G")
    ******* .FormatConditions.Delete
    ******* .FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
    ******* Formula1:="=""x"""
    *** With .FormatConditions(1).Font
    ******* .Bold = True
    ******* .Italic = False
    ******* .ColorIndex = 2
    *** End With
    ******* .FormatConditions(1).Interior.ColorIndex = 3
    End Sub

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: highlight selection cell that meets criteria and multiple cells if not

    Cross-post: http://www.ozgrid.com/forum/showthread.php?t=152125

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1