Create progress bars with Conditional formatting

1. Create cells with Percentage values and select them.

2. Go to Home, select   Conditional Formatting, and then choose  Data bars.

3. Select More Rules. 
   Set Minimum Type to Number and Value of 0.
   Set Maximum Type to Number and a Value of 1.
   Change Fill and Border settings as needed. 

   
   Tip: Change text alignment on cells to move numbers to left, right, or center on the Home tab.

For more on Conditional formatting, see Use conditional formatting to highlight information. 

1. Create cells with percentage values and select them.

2. Go to Home, select   Conditional Formatting, and then choose  Data bars.

3. Select More Rules. 
   Set Minimum Type to Number and Value of 0.
   Set Maximum Type to Number and a Value of 1.
   Change Fill and Border settings as needed. 
   
   
   ​​​​​​​Tip: Change text alignment on cells to move numbers to left, right, or center on the Home tab.

For more on Conditional formatting, see Use conditional formatting to highlight information. 

Conditional formatting doesn't fully support progress bars in Excel for the web. You can, however, create progress bars in the Excel desktop app.

• To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.

  

Don't have the Excel desktop app? Try or buy Microsoft 365.