Note related background color of a cell

M

mauseth

I am trying to find out if it is possible have the background color of
a cell automatically change colour when a Note is added to it, and if
so how do I go about it please
 
A

AB

Then you might be out of luck.
You sure can have the top-right corner highlighted of the cell but
setting its background to a specific color once the comment is added -
that might be tricky.
I can only think of running a code that would loop through all the
cells and highlight the ones with comments and unhighlight the ones
without but it's an ugly solution as it wouldn't depend on the event
of the comment actually being added (i.e., in that point in time).
Maybe there will be some better ideas from other folks in here.
 
M

mauseth

Then you might be out of luck.
You sure can have the top-right corner highlighted of the cell but
setting its background to a specific color once the comment is added -
that might be tricky.
I can only think of running a code that would loop through all the
cells and highlight the ones with comments and unhighlight the ones
without but it's an ugly solution as it wouldn't depend on the event
of the comment actually being added (i.e., in that point in time).
Maybe there will be some better ideas from other folks in here.




- Show quoted text -

Thanks anyway, I won't hold my breath
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top