UseExcel - Blood Sugar Test

Excel: Track your own health.

Random Blood Sugar Test

What is a random blood sugar test?

This test measures your blood sugar without considering the last time you ate a meal, snack or beverage containing calories.

What's normal?

If your random blood sugar is less than 100 mg/dL (5.55 mmol/L), it's normal.

What level suggests prediabetes?

If your random blood sugar is greater than 100 mg/dL (5.55 mmol/L) but less than 199 mg/dL (11.05 mmol/L), you may have prediabetes.

What level suggests type 1 or type 2 diabetes?

A blood glucose of 200 mg/dL (11.11 mmol/L) or higher suggests you have either type 1 or type 2 diabetes.

Source: The Mayo Clinic.


Disclaimer:

This web page is not meant to be a guide to your health. Nor is it meant to be a substitute for regular visits to your doctor. This web page is for Excel instructional purposes only, using everyday situations.

How to make your own Random Blood Sugar Test tracker.

  1. Label your project in cell A1 as Random Blood Sugar Test.
  2. Make a header row in row 2, with titles Date, mg/L, Lower Limit, Upper Limit in Columns A to D.
  3. Conditionally format the cells in column B, the column that will hold your daily blood sugar values. To do this, go to the Format menu, Conditional Formatting ...
    Conditional Formatting - what you see first
    Step 3a: What you see first.
    Conditional 1 - less than
    Step 3b: Condition 1 - change the 2nd from left drop down box from "between" to "less than".
    Then click the Format... button.
    Conditional 1 - Format Cells
    Step 3c: Condition 1 - Format Cells - what you see first.
    Conditional 1 - Pattern tab
    Step 3d: Condition 1 - Format Cells - Pattern tab, pick a color, click OK.
    Conditional 1 - Pattern tab
    Step 3e: Condition 1 - what it should look like.
    Conditional 1 - Pattern tab
    Step 3f: Condition 2 - after clicking the Add >> button.
    Repeat steps 3a to 3f for conditions 2 & 3 to get the effect below:
    Excel Conditional Formatting
  4. Enter your first test date in cell A3 and then use the fill cursor to create as many more dates as you wish.
  5. Enter the lower and upper limits of 100 and 200, respectively, in cells C3 and D3. Then use the fill cursor to fill in the limits in row 4 downwards. Why are we adding lower and upper limits to the columns? They don't change? The answer is that we are going to chart the blood sugar test values. Charting the lower and upper limits will tell us instantly if we are within the acceptable limits.
  6. Your Excel worksheet should look like the one below.
Blood Sugar Test worksheet example

How to chart your own Random Blood Sugar Test results.

  1. Select cells A2 to D20 (using the example above).
  2. Click the Chart Wizard icon on the Standard toolbar.
  3. Step 1 of 4 of the Chart Wizard. Select the Line chart type.
    Select the chart sub-type that displays markers at each data value.
    Click the Next button
    Chart Wizard Step 1
  4. Step 2 of 4 of the Chart Wizard. Confirm the Data Range and the Series for the chart.
    Chart Wizard Step 2, Data Range tab

    Chart Wizard Step 2, Series tab
    Click the Next button.
  5. Step 3 of 4 of the Chart Wizard. Enter the chart options.

    Chart Wizard Step 3, Titles tab
  6. Step 4 of 4 of the Chart Wizard. Decide where the chart should go.

    Chart Wizard Step 4, Chart Location
  7. And the final result of the chart:

    final Blood Sugar Chart
Here is the completed Excel workbook BloodSugarTest.xls

[Top of Page]