CF to grey out the two unused options
Jock wrote:
Perfect, Thank you
You are welcome.
You may want to consider a second CF of this:
=COUNT($A$1:$C$1)1
Format appropriately (bright yellow?) to highlight when more than one entry has
been made in the range.
|