+ Reply to Thread
Results 1 to 2 of 2

Additional formatting: font-, cell- and gridcolour

Hybrid View

  1. #1
    Registered User
    Join Date
    10-26-2006
    Posts
    1

    Additional formatting: font-, cell- and gridcolour

    I have read about VBA codes to set the cell clour i.e:

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim icolor As Integer

    If Not Intersect(Target, Range("A1:A10")) is Nothing Then
    Select Case Target
    Case 1 To 5
    icolor = 6


    Can sombody help me with the codes for font and grid colours?

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Selection.Font.ColorIndex = 3
    Selection.Interior.ColorIndex = 6
    ActiveWindow.GridlineColorIndex = 8

    HTH
    Carim

+ 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