Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hey all
I'm sure this question has been asked a few times before ;o). Basically I'm looking for a validation rule for the below. I have a row of data, say A1,B1,C1,D1 where a1 can have either value or used or Inuse. When the user selects 'Unused' from the dropdown, they will be forced to enter in details in to the other cells. I.e Name, Department, Cost Center ect... I've tried an IF statement but not being technical this has me stumped. Any help provided would be a godsend. Much thanks! Mel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Check/Tick box's and Mandatory cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |