# Calculated Conditional Formatting

0
3478

The Excel HelpDesk Support team received the following request for help:

### Problem – Display values for calculated values in a Spreadsheet

I am trying to come up with a formula where if the sum comes to 0 in the next cell I want it to show Low, but if it comes to 1 then it should show Med or 2 or higher then it should show High

The following sample table of calculations was received to demonstrate the request

### Use IF statement to create the formula result

First step we will create an IF statement formula to automatically populate the column “STEP 5” with the value “Low”, “Medium” or “High”. Using the values provided by the request we have the following rules for the IF statement

0 – Low
1 – Medium
2+ – High

We will also include in this formula a case for any value other than those specified in the request, in these cases we will display nothing for the result. So in a sample spreadsheet we create the formula.

### Include Conditional Formatting to highlight the entries

Now to highlight the entries as they are made we will include specific conditional formats for each of these values. Start by selecting the entire column “STEP 5”, then select Conditional Formatting. See the screen display below for the specific format options to select.

If you would like a copy of a sample spreadsheet that includes this formula and conditional formatting click on the following download link