Change color of cell dependent upon color of another cell

I have a task list table. Cell A1 is a checkmark cell. Cell B1 is a description of a task (i.e. clean car). I want both A1 and B1 cells to be filled red if A1 is not checked but have no fill if A1 is checked. How do I do this? I know that a A1 check mark box that is checked = TRUE and not checked = FALSE but don't know how to create a if/then formula that can affect cell B1 (i.e. highlight B1 red if A1 is checked) without disturbing the text that I write into B1 (i.e. clean car, go grocery shopping, feed dog, etc). Any thoughts?

Posted on Jan 22, 2019 12:39 PM

Reply

Similar questions

3 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Change color of cell dependent upon color of another cell

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.