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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
cell comments on changing sheet
Excel Facts
Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Similar threads
- Replies
- 5
- Views
- 215
- Replies
- 1
- Views
- 360
- Replies
- 2
- Views
- 174
- Replies
- 3
- Views
- 175
- Replies
- 10
- Views
- 224
