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!
Bookmarks