I have a big sheet and I want to find all the cells with a yellow
background.
When that is done I want to insert the word "yellow" or some other
string in the cell (not overwrite).
Is there a simple way to do that ?
Use conditionals. These are described in the User GUides. See
http://documentation.openoffice.org/
After reading the relevant chapter I come to the conclusion that
conditional formatting is the opposite of what I want. Am I wrong ?
In conditional formatting I can say:
if cell content is "suchstring" then apply style "suchstyle"
Now the problem here is that the cells are not "styled" they only
have a yellow background inherited from the Excel import.
What I would like to do (automatically if possible) would be:
if cell background is "yellow" then concatenate "yellow string" to
the cell contents.
And that does not seem to be covered by conditional styling.
Jean-Christophe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
