XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Formatting Grids/Version 7.0

Revision as of 16:25, 29 August 2012 by Antonio.remedios (talk | contribs) (Created page with "In v7 formatting is available on XLCubed right-click menu as option, Format This Member. 350px|centre So if we want to format Accessories row, we right-click o...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

In v7 formatting is available on XLCubed right-click menu as option, Format This Member.

FG1.png

So if we want to format Accessories row, we right-click on Accessories, XLCubed, Format This Member. We are presented with the standard Excel Format Cells window from which we can choose any of the usual settings to change.

FG2.png

We will choose Fill, select a colour and OK. The refreshed grid now looks like this:

FG3.png

The lower half of the XLCubedFormats sheet shows that both Member Accessories and associated row data will be filled in pink.

FG4.png

If you do not want the data to be filled go to the XLCubedFormats sheet, right-click the Data Format cell for Accessories and remove the fill colour by setting the backgound to 'No Colour'.

FG6.png


FG5.png

Once refreshed, the grid now looks like:

FG8.png