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.
Saturday, May 26, 2018
yogi_Conditionally Format Cells In Column A Which Match The Entry In DropDown List In Cell G6 Or The Group Which They Belong To From Sheet2 - Part2
I try to create timetable and I want to create formula which will help students or them parents to find when they have a class or private lesson.
I will attach link below.
What I want exactly is, if I pick name from List in cell G6 I'd like to that name to be highlighted in all spreadsheet, in addition kid belongs to the different classes/groups, Latvian, Trolls etc and I'd like to be those groups highlighted as well when I pick child name.
Simplyfing if I pick name Amelia in G6 I'd like to highlighted that name and Troll group as she belong to that group as well.
I was able to use match formula, but once I picked name in G6 and it was matching with the name from A column it was highlithing name but in G6 not in A column.