Hi all... this forum has been great over the past few days. I'm learning quite a bit.

When the value of the checkbox is true then I would like a linked cell to be filled with a specific color (green) and a different color (red) when the value is false.

In other words, I would like all the affected cells to be red until it becomes a true statement.

Does that make sense?

Let me know if you need a better explanation.