Leading the way in Microsoft Office Development

Step 1 - Highlight the cells

This example shows you how to apply conditional formatting that will highlight any cells that contain a value between the values of 5 and 20.

Select the cells the you want to apply conditional formatting to, in this case "B2:E9".

Step 2 - Enter Conditions

Press (Format > Conditional Formatting) to display the Conditional Formatting dialog box.

Select "Cell Value is" from the first drop-down box and "between" in the second dialog box.

Enter the constants 5 and 20 in the appropriate boxes.

Click the Format button to apply your specific formatting, in this case we are just applying a grey background.

Press OK to apply the conditional formatting.