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

When you say 'a Note' - do you mean 'Comment'?

On Feb 3, 2:18*pm, wrote:
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

On Feb 3, 2:36*pm, AB wrote:
When you say 'a Note' - do you mean 'Comment'?

On Feb 3, 2:18*pm, wrote:



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- Hide quoted text -

- Show quoted text -

Yes I mean 'Comment'

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.


On Feb 3, 3:05*pm, wrote:
On Feb 3, 2:36*pm, AB wrote:

When you say 'a Note' - do you mean 'Comment'?

On Feb 3, 2:18*pm, wrote:

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- Hide quoted text -

- Show quoted text -

Yes I mean 'Comment'

On Feb 3, 3:13*pm, AB wrote:
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.

On Feb 3, 3:05*pm, wrote:



On Feb 3, 2:36*pm, AB wrote:

When you say 'a Note' - do you mean 'Comment'?

On Feb 3, 2:18*pm, wrote:

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- Hide quoted text -

- Show quoted text -

Yes I mean 'Comment'- Hide quoted text -

- Show quoted text -

Thanks anyway, I won't hold my breath