+ Reply to Thread
Results 1 to 2 of 2

CF a name on one sheet based on their status on a data sheet

  1. #1
    Registered User
    Join Date
    09-08-2009
    Location
    Hawaii
    MS-Off Ver
    Excel 2013
    Posts
    68

    CF a name on one sheet based on their status on a data sheet

    I've attached a dummy sheet to help see what I'm trying to go after.

    I have a Master Data sheet with all names and what their status is (Present or Outbound). On a separate sheet (Assigned) I have a bunch of duties with the associated primary and alternate name.

    What I'm trying to accomplish is, if on the Data sheet the member is marked as "Outbound", on the Assigned sheet I'd like for the members name to CF red.

    I've tried a vlookup formula inside a CF but can't get it right.

    Thanks in advance for any help!
    Attached Files Attached Files
    Last edited by purdue7997; 08-14-2018 at 02:43 PM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: CF a name on one sheet based on their status on a data sheet

    Select the entire range you want to highlight on the Assigned worksheet

    Conditional Formatting
    New Rule
    Use a formula to determine...

    =COUNTIFS(Data!$A$2:$A$1000,$B2,Data!$C$2:$C$1000,"Outbound")>0

    Format as required
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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. Replies: 6
    Last Post: 01-30-2017, 03:07 PM
  2. Get data from one sheet to other based on one cell status in excel
    By notbanme in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2016, 04:40 AM
  3. Trying to move a row from one sheet to another based on a cells status
    By stiffanyj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2016, 03:00 PM
  4. Replies: 2
    Last Post: 01-23-2016, 01:16 PM
  5. moving a row to another sheet based on cell status
    By discglide in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-13-2014, 11:31 PM
  6. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  7. As user fills out data sheet, then fill out a results sheet based on data sheet entry
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-13-2012, 03:57 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