| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Formatting Grids"
| Line 1: | Line 1: | ||
{{VersionDisambiguation|pageVersion=|disambiguationPage=Formatting Grids/Versions}} | {{VersionDisambiguation|pageVersion=|disambiguationPage=Formatting Grids/Versions}} | ||
| − | + | ||
<!--I've transcluded the appropriate version above so that we don't have to repeat the information.--> | <!--I've transcluded the appropriate version above so that we don't have to repeat the information.--> | ||
Revision as of 13:46, 30 April 2012
 |
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 Data Format cell for Accessories and remove the fill colour.
