Autocolor is invaluable for model builders who want to effortlessly distinguish between cells based on their types (see image below for format examples).
To use Autocolor, simply toggle it on, and the cell style will be dynamically updated to match the content you enter.
You can also apply it on existing content simply by selecting the range and clicking autocolor selection.
The font and background color can naturally be customized.
When exporting to PowerPoint and Word, UpSlide will automatically uncolor the selection and recolor it after the export. In most cases this is desirable but you can also deactivate this option.
You also have a button to manually uncolor the selected range.
The autocolor feature can give a specific format to the following cell types:
- Date or Time
- Formula with plugs (hard-coded inputs)
=A1 + 2
- Direct link
- Any other formula
=A1 + A2 * A3
When your cell contains a formula, you can check whether it contains references to another sheet or workbook by setting this as a different color:
- Formula with precedents in a different worksheet
=SUM( Sheet1!A1:A10 )
- Direct link to a cell in a different workbook