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?

migrated from superuser.com Dec 20 '17 at 11:54

This question came from our site for computer enthusiasts and power users.


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