I'm trying to make a column change color whenever a specific range within that same column has the same character, per example, I want cells C1:C50 to change to the color green when all the cells in C10:C50 have the value 1 on them.

I've tried this custom formula, that doesn't seem to work.

```
=C10:C50=CHAR(10004)

```

Sorry if this is an easy fix, but have been looking for answers and haven't found something that suits my problem