Bingo! That did the trick.

Why did it not work the way I wrote it?


"Kevin B" wrote:

In D7 format the cell as you have indicated in your post, but change the
function to the following:

=NOT(Y7)
--
Kevin Backmann