Results 1 to 1 of 1

How Conditional formating in VBA

Threaded View

abid.ratnani How Conditional formating in... 09-04-2013, 06:50 AM
  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    2

    How Conditional formating in VBA

    =OR(CELL("ROW")=CELL("ROW",A1))

    In the code module of the worksheet containing the conditional formatting:
    Option Explicit

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Target.Calculate
    End Sub
    Attached Images Attached Images
    Last edited by abid.ratnani; 09-04-2013 at 06:58 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 01-23-2014, 10:14 AM
  2. Replies: 6
    Last Post: 08-14-2006, 05:00 PM
  3. Replies: 2
    Last Post: 03-27-2006, 12:10 PM
  4. Install dates formating using conditional formating?
    By Jerry Eggleston in forum Excel General
    Replies: 2
    Last Post: 11-09-2005, 01:49 PM
  5. Replies: 1
    Last Post: 03-08-2005, 03:06 PM

Tags for this Thread

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