View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Conditional Formatting based on Non Blank Cells

Need more specific info.

if they type something in one category


And what cells would they be typing into?

I want the other two categories to grey out.


And where are these categories?

--
Biff
Microsoft Excel MVP


"Ashley1432" wrote in message
...
I have a form for users to fill out and I only want them to fill out one of
three categories. So if they type something in one category I want the
other
two categories to grey out. How can I do that?