View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default 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.