Tick appropriate box

[sujittalukde]

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]

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]

Thanks Jan, your trick is fully working.Many Many Thanks