Civil LAB - Excel
  • What is CIVIL LAB Excel?
  • Introduction
    • How to use ? Installation
    • Introduction of the modules
    • Copy right agreement
  • Documentation
    • Ribbon Tools
      • Formatting tools
        • Color It
        • Advanced Formatting
        • Auto Units
        • Group color
      • Utilization Tools
        • Pro copy
        • Level Sum
      • EuroCode Tools
        • Eurocode 4
        • Eurocode 3
        • Eurocode 2
          • Creep Coefficient
        • Eurocode 0 & 1
      • Database tools
        • Engineer Database
        • Group to index
        • Index to group
    • Built-in functions
      • General Functions
        • CL_G_TabelInterpolation
        • CL_G_CreateListTablePicker
        • CL_G_ListTableFind
        • CL_G_Table_find
        • CL_G_VlookupTable
      • Database Function
      • Eurocode function
      • Mechanical functions
        • CL_M_Rebars_A
        • CL_M_Recdata
        • CL_M_HProfileData
        • CL_M_Zel
    • Ready made Excel
      • Parametric tool : input output
      • Composite beam stiffness
    • Excel-Python
  • Contacts and development
    • For Programmers
      • Civil LAB framework
      • Resources
      • Naming Rules
      • Guides to Function Modules
      • Guides to Data Tables
      • Guides to Ribbons
    • For Engineers
      • What is possible?
    • For Supporter
      • Donation / contribution
    • Contact infomation
  • 💾Downloads
  • Road map
    • Road Map
Powered by GitBook
On this page
  1. Documentation
  2. Ribbon Tools
  3. Formatting tools

Color It

to colour cells based on the colour index by Hex or RGB numbers

PreviousFormatting toolsNextAdvanced Formatting

Last updated 3 years ago

to colour cells based on the colour index by Hex or RGB numbers inside the cell. useful for define the colour semi-automatically in excel. and can used together with Xchange PDF editor to get automatic measurement management.

Step1: to create measurement on the pdf with Xchange PDF

Step2: export the measurment data in .CSV

Step3: open the .CSV file in Excel and copy the sheet to CivilLAB excel

Step 4: use the colour it to mark the colour, perhaps you can also add a screen shot to show the meaning of each colour, and do you following calculations.

In the follow videos shows how to use it in combination with XChange PDF editor () to get a quick measurement or quantities calculation based on the plans.

https://pdf-xchange.eu/