Yes, it is definitely possible, take a look:
Using Excel 2013’s conditional formatting features, you can create progress bars on your spreadsheets. Progress bars are used to graphically represent the advancement of the data. Essentially, you get a chart-like effect within the rows and cells themselves.
Below is an example of the setup that you should have before you start. I will use Cold/Hot as my demonstration. I also stretched the E cell to make the progress bar longer. This is done to see a more accurate bar, but this step is not a requirement. As you can see, I put the number 12 in the progress bar cell. This number will be the percentage of the bar that is shaded.
![enter image description here](../../I/static/images/50019a23f4980a01a3bb81fb3ed5b80e074059d1e0e28b79fbe4aac481d84964.png)
From the Excel ribbon, select Conditional Formatting and then Data Bars. Next, select More Rules..
![enter image description here](../../I/static/images/424d7fdc7d54ea65d114b533d8ff6318120115a16a42a40934a9a375c0f189c4.png)
Now, you should see a window which will allow you to create a new formatting rule. For this step, we want to adjust the settings as follows:
Type: Chose Number, both Minimum and Maximum.
Value: Set the Minimum value to 1 and the Maximum value to 100.
Finally, chose your color, and click OK.
![enter image description here](../../I/static/images/48673bf992b70e639be4b29307f69f50e9ddf1ac8719c97919bde949e1f45497.png)
f you have adjusted all of the previous settings correctly, you should now see a progress bar.
![enter image description here](../../I/static/images/a752052c9a900c0625f6ca42105626b73406dcfeca452c44db3ca2c222010171.png)
@stevehilton You are welcome! Fell free to mark this answer as accepted ;) – duDE – 2016-01-13T18:02:53.490