Thanks! So I tried applying this to my whole sheet rather than just a column (ex. A1-A3) but it started randomly highlighting empty cells green. And the cells that already are on the list to be colored green didn't get turned green. How would you apply that conditional formatting to a whole sheet rather than just a column?