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, privacy policy and cookie policy