+ Reply to Thread
Results 1 to 1 of 1

Translate 2007 Conditional Formatting in 97-2003

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    06-03-2008
    Posts
    387

    Translate 2007 Conditional Formatting in 97-2003

    Hi,

    I've created the below VBA in Excel 2007. I don't have a computer with 97-2003 to do testing on it, so I'm hoping someone can help me translate it to be backwards compatible. Thanks.

        With Worksheets(mainWS).Range(Worksheets(mainWS).Cells(firstSelectionMenu, upgradeSelectionCol), Worksheets(mainWS).Cells(lastSelectionMenu, upgradeSelectionCol))
            .Validation.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="=$A$1:$A$" & FinalRow
            .FormatConditions.Add Type:=xlExpression, Formula1:="=LEFT(D11,7)<>""Upgrade"""
            .FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
            .FormatConditions(1).Interior.ColorIndex = 1
            .FormatConditions(1).StopIfTrue = True
        End With
    Last edited by Leith Ross; 08-21-2009 at 03:41 PM.

+ 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