Apr 262023
- Go to Google Drive
- Open the spreadsheet from last week
- Scroll down to a clear area
- Highlight a whole rectangle for your picture
- Put a border around it
- Whith the area still selected:
- Click on “Format” – “Conditional formatting”
- Select the range
- “Text contains”
- Type in “r” (for red)
- Change the fill colour to red
- Repeat for “b” (for blue)
- Make a Union Jack flag by typing “r” and “b” in the cells