Note related background color of a cell

  • Thread starter Thread starter mauseth
  • Start date Start date
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
 
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.
 
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
 
Back
Top