View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lisay lisay is offline
external usenet poster
 
Posts: 15
Default Making a cell mandatory if another cell has a particular value

Hi, any help would be appreciated!

I am trying to create a template where people fill out information about a
user. I want cell C6 to be filled out (NOT empty) if cell C4 = "XX" or C4 =
"YY".

Then, I want to be able to save the template where C6 is blank so that
people can fill it out later;

Thank you!
Lisa