Re: Lotus123 - changing cell color conditionally....



"Britt Turnbull" <invalid@xxxxxxxxxxxx> wrote in message
news:uotxTxdprKqf-pn2-HXTh1SXT9w2N@xxxxxxxx
I have googled and found reference to @setstyle. I can get that to work,
however I can't get it to set the background color and the contents at
the same time.

From my experience with @setstyle, it's probably easier to create two
formulas in separate cells - one for the contents and one for the background
colour.

Nope @setstyle works great.... and Lee also provided extremely helpful
support, for which I am very greatful.

Unfortunately, much as I appreciate the work that Lee Mosqueda did on this,
at the end of the day you can't expect it to do the things which Excel's
built-in condtional formatting does.

If excel didn't need windows then it would be a viable alternative, but
it does and I don't

thanks,
Britt
--
Britt - britt os2ecs co uk...
Winxx.. keep the apps.. junk the OS.. => http://www.ecomstation.com
System uptime is 15 days 11:58 hrs/mins
.