Data bars in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to apply data bars to the selected range in Excel using conditional formatting.

Excel

Selection.FormatConditions.AddDatabar().[1]

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

ADelete

BAddColorScale

CShowValue = True

DClear

Attempts:

3 left

💡 Hint

Common Mistakes

Using methods like AddColorScale instead of setting properties.

Trying to delete the format instead of modifying it.

The ShowValue property controls whether the cell value is shown alongside the data bar.

2fill in blank

medium

Complete the code to set the minimum threshold type for a data bar to be the lowest value in the range.

Excel

With Selection.FormatConditions(1).DataBar
  .MinimumPoint.Modify [1]
End With

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

AxlConditionValueNumber

BxlConditionValueFormula

CxlConditionValuePercent

DxlConditionValueLowestValue

Attempts:

3 left

💡 Hint

Common Mistakes

Using xlConditionValueNumber which requires a specific number.

Using xlConditionValuePercent which is for percent values.

The xlConditionValueLowestValue sets the minimum point to the lowest value in the selected range.

3fill in blank

hard

Fix the error in the code to set the maximum threshold value of a data bar to 100.

Excel

Selection.FormatConditions(1).DataBar.MaximumPoint.Type = [1]

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

AxlConditionValueNumber

BxlConditionValuePercentile

CxlConditionValueFormula

DxlConditionValueLowestValue

Attempts:

3 left

💡 Hint

Common Mistakes

Using percentile or formula types when a fixed number is needed.

Using lowest value which is for minimum threshold.

To set a specific number as the maximum point, use xlConditionValueNumber.

4fill in blank

hard

Fill both blanks to set the maximum threshold type to number and its value to 100 for a data bar.

Excel

With Selection.FormatConditions(1).DataBar.MaximumPoint
  .Type = [1]
  .Value = [2]
End With

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

AxlConditionValueNumber

B100

CxlConditionValuePercent

D50

Attempts:

3 left

💡 Hint

Common Mistakes

Using percentile type instead of number.

Setting value to 50 instead of 100.

Set the type to xlConditionValueNumber and the value to 100 to define a fixed maximum threshold.

5fill in blank

hard

Fill all three blanks to create a data bar with minimum type lowest value, maximum type number, and maximum value 200.

Excel

With Selection.FormatConditions.AddDatabar
  .MinimumPoint.Type = [1]
  .MaximumPoint.Type = [2]
  .MaximumPoint.Value = [3]
End With

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

AxlConditionValueLowestValue

BxlConditionValueNumber

C200

DxlConditionValuePercentile

Attempts:

3 left

💡 Hint

Common Mistakes

Using percentile for minimum or maximum types.

Setting maximum value to a wrong number.

This sets the minimum point to the lowest value, maximum point type to a fixed number, and maximum value to 200.