I have a table that I use to track activity. There are two different methods that our members can achieve the desired “activity level”, and I'm trying to find a way to set conditional formatting in the name field based on a comparison of values. I'm sure this will not be easy and may even require a script, but I'm not interested in how this will work in Google Docs.
Participants can fulfill the objectives of the activity by attending a certain number of events, or through "points for merit" that other activities receive. On my sheet, I have different fields that are calculated to achieve these numbers, and they appear in columns at the end of the month. I have one column to visit, and another column that matches their merits. Each column has its own conditional formatting, but I would like to configure it so that their member name is highlighted based on activity.
I'm currently looking for something that will basically go "if L6 = X OR M6 = Y, then make cell color Z" later, I want it to compare two arguments with a range and make the color based on a general comparison, but I know that I will need a script with a different formula nested in order to be able to do this with values. For now, I just want the Name fields to be highlighted in a specific color if either the L or M columns are within the required range.
Here is a link to a sample of my sheet. https://docs.google.com/spreadsheets/d/1jhftzbKWmUGaGhqW7zkwjVUVL0bXVvotNVSQl-u5oxQ/edit?usp=sharing
source share