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?

1 Answer 1


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


Choose the green formatting required and Done.

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.