PDA

View Full Version : Tick appropriate box



sujittalukde
05-15-2007, 09:51 PM
In my excel file, in one sheet user has to select option from drop down menu and in the another sheet excel should tick the appropriate box.
A sample file is attached wherein user will select Gender in sheet 1, cell B3. If the user select "M", a tick should appear automatically at cell B6 on sheet 2 & so on. How the same can be done?

Jan Karel Pieterse
05-15-2007, 10:55 PM
You could do it like this:

- format a cell with the wingdings font
- enter this formula:
=IF(LOWER(Sheet1!$B$3)="m";CHAR(254);CHAR(168))

sujittalukde
05-16-2007, 03:36 AM
Thanks Jan, your trick is fully working.Many Many Thanks