| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Formatting Grids
 |
This article refers to the latest XLCubed version. For other versions, see Formatting Grids/Versions. |
In v7 formatting is available on XLCubed right-click menu as option, Format This Member.
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.
We will choose Fill, select a colour and OK. The refreshed grid now looks like this:
The lower half of the XLCubedFormats sheet shows that both Member Accessories and associated row data will be filled in pink.
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'.
Once refreshed, the grid now looks like:
