On 11/12/2008 17:53, Dotan Cohen wrote:
2008/12/11 Harold Fuchs <[email protected]>:
http://www.openofficetips.com/blog/archives/2005/03/conditional_for_3.html
That looks like another excellent abandoned project, thanks! I will
try to contact the author as there is some good stuff on that site.
However, I would like to add an additional condition that if a cell is
already coloured, it should not be changed. And idea how to do that,
as the only options one has are "cell value is" and "formula is".
Thanks!
I don't know how to do this. There is a STYLE() function so you might be
able to include it in the "formula is" to say set cell blue if its row
number is odd *and* its *style* is "default". But simply colouring a
cell doesn't (??) affect its style so this would only work if all your
colour changes were effected via styles.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
