i have a sheet that has a dropdown list of names, when i select a name a table comes up and boxes are coloured in based on conditional formatting. when i add a comment the usual way it remains there no matter what name i have selected from the dropdown list, when i only want it to be there in that cell for that person. any ideas how i can get around this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
cell comments on changing sheet
Similar threads
- Question
