I am trying to get a particular result, but I have obviously got the syntax slightly wrong in my formula and I wonder if someone might look at it and indicate where I went wrong.
Here is the formula:-
I have this conditional formatting rule:
It is applying a light green fill color when the conditions are met.
What I would like to do is have every group of 14 rows alternate between this color and a slightly different color. Is it possible to setup another...
I have a 2 column table with a list of items, each getting a score from 0 to 1. I'm trying to create a third column that will generate one of 7 dfferent text values, each corresponding to a range of possible scores. Here's the formula I have: