Macro to paint initial column grey

[Former Member]

Hello All,

I am trying to change the background color from the initial column in APO SNP, but I have no experience in writing macros.

I found out that I can Use CELL_BG() with X= 8 but now I am on the end. Could anybody give me a hint how to go on?

Regards

SK

Now i can change the color of the first cell in grey

but what can i do that the macro goes down all cells in the row to paint them grey

Here what I did:

step (paint cell: (38 Iterations: Initial; M05.2013)

Cell: RSFC (Initial) (Attributes) =

Operator: CELL_BG( 8 )

Can anybody help?

Edited by: Skanderbeg on Jun 9, 2011 4:18 PM

[Former Member]

Hi SK,

The CELL_BG( X ) can be applied to a row or a cell.

To change background color of one cell follow the below process:

1.Create a step with one iteration

2.Assign the desired cell with CELL_BG ( X ) -X being the color code

To change the background color of n cells within one row just increase the number of iterations in that step to n.

For one column the only option I can think of is to assign each cell for that column with the desired color one by one i.e to follow first process and add the desired cells in step 2.

Let me know if this helps!!

Regards,

Jatin

[aparna_ranganathan]

Hi

The problem is because , you are iterating (or repeating) the process 38 times . To paint just the initial cell gray , change the iteration range in your macro step - it should be 1 iterations : inital : initial and not 38 iterations :inital to M05 2013

Thanks

Aparna