This guide includes 3 how-to topics for Background Pattern and Color, covering how to set a cell pattern, a foreground color, and a background color; all 3 topics are available without membership.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Set a Cell Pattern | Free |
| 2 | 2. Set a Cell Foreground Color | Free |
| 3 | 3. Set a Cell Background Color | Free |
How-to Guide
1. Set a Cell Pattern
Entry path: Bottom toolbar Tools > Home tab > Cell Pattern/Background Settings > Pattern
- Tap Tools on the bottom toolbar.
- Select the Home tab.
- Tap Cell Pattern/Background Settings.
- Tap Pattern and choose a preset pattern style.
- Tap OK to apply the setting.
Success Criteria
- Visual result: The selected cell shows the chosen pattern style.
- Next step available: You can continue adjusting the foreground color or background color.
Tips While Using
- Common issue: If you do not select the target cell first, the result may not apply where you expect.
2. Set a Cell Foreground Color
Entry path: Bottom toolbar Tools > Home tab > Cell Pattern/Background Settings > Foreground Color
- Tap Tools on the bottom toolbar.
- Select the Home tab.
- Tap Cell Pattern/Background Settings.
- Tap Foreground Color and choose a color.
- Tap OK to apply the setting.
Success Criteria
- Visual result: The foreground display color of the selected cell is updated.
- Next step available: You can continue changing the pattern or background color.
Tips While Using
- Common issue: Foreground color changes are usually easier to notice when a pattern style is already applied.
3. Set a Cell Background Color
Entry path: Bottom toolbar Tools > Home tab > Cell Pattern/Background Settings > Background Color
- Tap Tools on the bottom toolbar.
- Select the Home tab.
- Tap Cell Pattern/Background Settings.
- Tap Background Color and choose a color.
- Tap OK to apply the setting.
Success Criteria
- Visual result: The selected cell shows the new background color.
- Next step available: You can continue editing the worksheet or save the file.
Tips While Using
- Common issue: If the selected color is too light, the result may be hard to notice. Try a darker color to confirm the change.