+ Reply to Thread
Results 1 to 17 of 17

Excel - cell activity

  1. #1
    Registered User
    Join Date
    03-04-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    31

    Excel - cell activity

    Hi there, I am looking to find out how you can have a cell that has a word in this and when deleted, is deleted from another cell also within the same tab

    For example - 'Jeff' works on the 27th June on X project (cell A1) - therefore cant work on project Y also on 27th June (cell A13) therefore cell A13 needs to be coloured red as he is unavailble. Equally, if 'Jeff' was take off project X (cell A1) we could delete the info in this cell and a formula would also change cell A13 to 'blank' therefore showing that he is avialble

    I hope this makes sense and someone can help

    Thanks

    Matt

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Excel - cell activity

    Please show it in excel with expected outcome and the method for better understanding


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    03-04-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Excel - cell activity

    I have tried to attach a document but I am not allowed to? : (

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Excel - cell activity

    Quote Originally Posted by matthew.lawson View Post
    I have tried to attach a document but I am not allowed to? : (
    Not sure what do you mean by the above quote

  5. #5
    Registered User
    Join Date
    03-04-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Excel - cell activity

    I am unable to show you in excel as I cant attach a docuemnt to show you

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Excel - cell activity

    We just require a dummy excel file filled with x y z of data for understanding your requirement, not the one which possess confidential informations

  7. #7
    Registered User
    Join Date
    03-04-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Excel - cell activity

    I have created this but I am unable to attach / upload it to this site?!

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Excel - cell activity

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.

  9. #9
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Excel - cell activity

    Hi matthew.lawson

    How about something along this line, in A1: Jeff and in the other cell say B1

    =IF(A1="","",A1)
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)

  10. #10
    Registered User
    Join Date
    03-04-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Excel - cell activity

    Attached

    So we are looking at Cell AV29 - when you delete this infomation it makes cell AV26 change from Red to a Blank cell

    how is this done?

    Thanks
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    03-04-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Excel - cell activity

    Thanks Kevin, it didnt work. Where would you put that formula - in the Cell A1 for example?

  12. #12
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Excel - cell activity

    You should use CF (Conditional Formatting) in this case, since we cannot change the cell color using formula in a cell.

    select from AV26 to Az26 and press Alt+O+D and in CF formula use
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In fill color select white background

    EDIT: Added Keyboard Shortcut
    Last edited by :) Sixthsense :); 03-06-2013 at 06:54 AM.

  13. #13
    Registered User
    Join Date
    03-04-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Excel - cell activity

    Apologies, I am not sure what you mean. How does this then link to the releven person? Can you show this on the spredsheet sent on a new tab?

  14. #14
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Excel - cell activity

    Refer post # 12 I have added the keyboard shortcut for CF. I believe you are aware of conditional formatting since you are already having a CF applied in cell AV26

  15. #15
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Excel - cell activity

    Hi matthew.lawson

    AV has conditional formatting, see the attached picture.
    Excel - cell activity.PNG

  16. #16
    Registered User
    Join Date
    03-04-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Excel - cell activity

    Hi kevin, i didnt update this spreadsheet - do you know how they go to that point?

  17. #17
    Registered User
    Join Date
    03-04-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Excel - cell activity

    HI Kevin, i didnt create the speadsheet - any pointers to how the person got to this stage?

  18. #18
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Excel - cell activity

    Hi matthew.lawson

    Unhide the columns (C:AU). Cells C26:AZ28 is where the conditional formatting as been applied.

  19. #19
    Registered User
    Join Date
    03-04-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Excel - cell activity

    Hi Kevin - thanks, only I dont know how to actually apply the conditional formatting

    any idea how to copy what they have done and apply with to another spreadsheet?

+ 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