Quote:
Originally Posted by FerrariEnzo
I tried it using values on the same spreadsheet but got an error
 |
Sorry, remove the quotations from the first part formula but leave quotations for "yes" and "no". add a $ in front of the letter ($A3) to lock in the column, then drag the formatting down your superstar list