Results 1 to 3 of 3

Vba code to conditionally format a specific range

Threaded View

  1. #1
    Registered User
    Join Date
    02-02-2012
    Location
    Austin, Texas
    MS-Off Ver
    Office 365
    Posts
    33

    Vba code to conditionally format a specific range

    I'm still a rookie at this and can readily use any help y'all can provide. I need to have some VBa code to do the following things:

    1. Conditionally format a range - cells in "a" should be filled in red with white bold text when value is >20
    (value of a is detrmined by subtracting the date in column b from the System date auto entered in c1)

    2. Prevent the user from inserting/deleting rows from the Insert menu and from the right click menu

    3. Allow users to insert rows that will be properly formatted by using a button (ax:hX) - they should also be able to delete a row (ax:hx).

    I realize that this is a rather large request but I am hopeful that there is indeed a generous individual in the group willing to lend me his/her expertise.

    Thank you

    DummyBook2.xls
    Last edited by kelwood; 03-07-2012 at 11:20 AM.

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