With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Thursday, December 25, 2014
yogi_Conditionally Format Cells B2 To B For Names In Column A Matching List of Names In Cell B2 Of Sheet1
post by Travisneedshelp: https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/jDfRUj8zZmQ Conditional "if" function across multiple sheets please help me
I'm not Excel or Sheet savvy enough to figure out the formula I need to complete this function. Basically I have a list of names separated by commas in Sheet 1, cell b2. I then need a conditional formatting formula that will search this list of names in sheet 1; and, in sheet 2, insert the word "present" if a specific person's name appears in the list. If not, it should mark "absent."