Hi Folks

Is there a way to show percentages complete using conditional formatting (preferably a thermometer type like the attached), on cells that contain text only?

The attached has a screen shot of what I would like it to look like based on the percentage in cells C11:C17.

Thanks in advance

cond_format12.xlsx