Use Background Color with 2 how-to topics, including setting a cell foreground color and setting a cell background color; choose a topic from the index and follow the steps.
How-to Index
| # | Topic | Membership |
|---|---|---|
| 1 | 1. Set a Cell Foreground Color | Free |
| 2 | 2. Set a Cell Background Color | Free |
How-to Guide
1. Set a Cell Foreground Color
Entry point: Bottom toolbar Tools > Home tab > Cell Pattern/Background Settings > Foreground Color
- Open the spreadsheet you want to edit and select the target cell.
- Tap Tools on the bottom toolbar.
- Select the Home tab.
- Tap Cell Pattern/Background Settings.
- Tap Foreground Color and choose the color you want.
- Tap OK to finish.
Success Criteria
- UI state: The selected cell shows the foreground color you chose.
- Next actions: You can continue editing other cells or save the file.
Tips While Using
- Common mistakes: If you do not select a cell first, the color may not be applied to the intended position.
- Environment limits: The spreadsheet must be opened in editable mode on Android.
2. Set a Cell Background Color
Entry point: Bottom toolbar Tools > Home tab > Cell Pattern/Background Settings > Background Color
- Open the spreadsheet you want to edit and select the target cell.
- Tap Tools on the bottom toolbar.
- Select the Home tab.
- Tap Cell Pattern/Background Settings.
- Tap Background Color and choose the color you want.
- Tap OK to finish.
Success Criteria
- UI state: The selected cell shows the background color you chose.
- Next actions: You can continue setting colors for other cells or save the file.
Tips While Using
- Common mistakes: Foreground Color and Background Color are different entries, so confirm the current option before applying a color.
- Environment limits: If the file is read-only, switch it to editable mode first.