Font styling (bold, italic, color) in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to make the text in cell A1 bold.

Excel

Range("A1").Font.[1] = True

Drag options to blanks, or click blank then click option'

ABold

BItalic

CColor

DUnderline

Attempts:

3 left

💡 Hint

Common Mistakes

Using Italic instead of Bold

Trying to set Color property to True

Using incorrect property names

Setting Font.Bold = True makes the text bold.

2fill in blank

medium

Complete the code to make the text in cell B2 italic.

Excel

Range("B2").Font.[1] = True

Drag options to blanks, or click blank then click option'

AUnderline

BBold

CItalic

DColor

Attempts:

3 left

💡 Hint

Common Mistakes

Using Bold instead of Italic

Trying to set Color property to True

Misspelling the property name

Setting Font.Italic = True makes the text italic.

3fill in blank

hard

Fix the error in the code to change the font color of cell C3 to red.

Excel

Range("C3").Font.[1] = RGB(255, 0, 0)

Drag options to blanks, or click blank then click option'

ABold

BColor

CItalic

DUnderline

Attempts:

3 left

💡 Hint

Common Mistakes

Using Bold or Italic property to set color

Misspelling Color as Colour

Not using RGB function correctly

The Font.Color property sets the font color. Using RGB(255, 0, 0) sets it to red.

4fill in blank

hard

Fill both blanks to make the text in cell D4 bold and italic.

Excel

With Range("D4").Font
  .[1] = True
  .[2] = True
End With

Drag options to blanks, or click blank then click option'

ABold

BColor

CItalic

DUnderline

Attempts:

3 left

💡 Hint

Common Mistakes

Using Color or Underline instead of Italic

Setting only one property instead of both

Mixing up the order of properties

Setting both Bold and Italic properties to True makes the text bold and italic.

5fill in blank

hard

Fill all three blanks to make the text in cell E5 bold, italic, and red color.

Excel

With Range("E5").Font
  .[1] = True
  .[2] = True
  .[3] = RGB(255, 0, 0)
End With

Drag options to blanks, or click blank then click option'

ABold

BItalic

CColor

DUnderline

Attempts:

3 left

💡 Hint

Common Mistakes

Using Underline instead of Color

Setting Color to True instead of RGB value

Mixing up the order of properties

Set Bold and Italic to True, and Color to red using RGB(255, 0, 0).