+ Reply to Thread
Results 1 to 3 of 3

if condition is true then lock, copy, and color the cells

  1. #1
    Registered User
    Join Date
    07-07-2020
    Location
    India
    MS-Off Ver
    office 2007
    Posts
    2

    if condition is true then lock, copy, and color the cells

    My worksheet contains Date in A1, and some number fields in B1, C1, D1, E1 After enter date in A2 it has to compare with date in A1 and if it is within 3 months then it have to lock B2, C2, cells and copy the values from B1 C1 to B2, C2 and change font color and cell color of B2 & C2.

    Is it possible with single "If" function, or I have to write macro for this.

    Please answer on IF & Macro for this

    Thanking you

  2. #2
    Registered User
    Join Date
    04-26-2020
    Location
    Massachusetts
    MS-Off Ver
    Office 365
    Posts
    93

    Re: if condition is true then lock, copy, and color the cells

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    07-07-2020
    Location
    India
    MS-Off Ver
    office 2007
    Posts
    2

    Re: if condition is true then lock, copy, and color the cells

    In the sheet A3 is date and R3 is A3 + 90 days.
    It has to check If R3<=A4
    then
    L4=L3, M=1,N4=N3, O=1 and Lock L4:Q4
    ELSE
    user has to enter values in L4, N4 manually and R4 = A4
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro that can fill up entire row with color if condition is true
    By Skroxzim in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-07-2019, 03:15 PM
  2. Replies: 3
    Last Post: 01-29-2018, 11:48 PM
  3. When condition true, need to copy range,
    By nnish in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-18-2016, 07:48 AM
  4. When condition true, need to copy range,
    By nnish in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-18-2016, 06:26 AM
  5. When condition true, need to copy range,
    By nnish in forum Excel General
    Replies: 2
    Last Post: 11-17-2016, 11:24 AM
  6. Replies: 1
    Last Post: 03-09-2016, 03:57 AM
  7. [SOLVED] Copy all row if condition is true
    By norlax in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2014, 12:01 PM

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