Formatting conditional on absence of comment
To the best of my knowldge... No... you would need to use VBA. That being
said if you were willing to insert a column next to the target of your
conditional formatting (the column could be hidden) then by creating a user
defined function in VBA (which you would use like any other Excel function)
you could create a flag (True or False) in the hidden column, which would
indicate whether the target cell has a comment in it or not. That would
require very minimal code...
--
HTH...
Jim Thomlinson
"Lon Sarnoff" wrote:
I have a spreadsheet which has conditional formatting in certain cells. I
would like to add as a condition that the cell does not contain a comment. I
want to use built-in conditional formatting as opposed to VBA coding. Can
that be done?
--
Lon Sarnoff
|