How can I create an Index with Text and Numbers such that the numbers and text have different formats, i.e. different fonts, sizes, colours; and still be able to automate the index finction.
You can use Conditional formatting:
- First, create two styles, one for text (IndexText) and one for numbers (IndexNumber) (F11, then right click on the right pane and select new)
- Select your range of cells in the index
- Click on the menu Format > Conditional > Condition
- Select Formula is and type
ISTEXT(M21)(replaceM21by the first cell in your index) - Then apply the style IndexText
- Add a condition and repeat for numbers.
The Title tells: Text & numbers in same Cell… , so no, CF doesnt work this way!
1 Like