🚀 go-pugleaf

In article <0f34YZW00WBN88i1sO@andrew.cmu.edu> Stephen Sorensen <ss9o+@andrew.cmu.edu> writes:
>Date: Thu, 19 Nov 1992 21:10:45 -0500 
>From: Stephen Sorensen <ss9o+@andrew.cmu.edu>
>Subject: Quattro Macros--Help!
>Hi folks,
>Can ANYONE answer my question about using macros in Quattropro (I'm
>using qp 4.0 for windows) ? All I want to do is have a macro go through
>and color all the cells with numbers; I want it to leave the blank cells
>alone. So far, I've got something like this:
>                    {IF #NOT#@Active_Cell}{RIGHT}
>                    {Setproperty....}
>                    {Right}
>
>I keep getting an error message about an invalid statement. Does anyone
>know how to properly use such an "IF" clause ? The Quattro manuals seem
>basically useless.
>
>Any help would be GREATLY appreciated.
>
>Thanks,
>Steve
>

First, sorry to all about my previous incomplete posting; I 
accidentally sent it in the middle of typing and couldn't stop it.  

There are two solutions to what you want to do.  The non-macro solution 
(which *sounds* as if it would suffice, based on your description) is to 
select /Options,colors,conditional and you can then set numeric values to 
display in whatever color you want.

A macro solution would be to use the fact that @cell can check whether a 
cell has a value in it: 

   {if @cell("type",a1)="v"}etc...

and you could cycle through the spreadsheet, perhaps using @cellindex in 
place of "a1".  The first solution is definitely the easiest if it does what 
you want.

-- Bob


***********************************************
Robert McDonald  / Internet: r-mcdonald@nwu.edu 
Fin. Dept., Kellogg School, Northwestern Univ.  
2001 Sheridan Rd., Evanston, IL 60208-2006   
voice: 708-491-8344 / Fax 708-491-5719    
***********************************************