2

I have a shopping list in column B and want to be able to use the =char(10004) in column C so then the item in the cell 'B' turns green.

Can this be done?

Improve this question

1 Answer 1

Reset to default
1

Please select ColumnB and Format > Conditional formatting..., Custom formula is and: 

=C1=CHAR(10004)

Choose the green formatting required and Done.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.