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 -
Click to expand...

Thanks anyway, I won't hold my breath
 
Top