Conditional Formatting: Data Bars

Feb 7, 2011 at 2:16 PM


I was wondering if it was possible to conditional format a cell as a data bar to indicate progress.



Feb 7, 2011 at 11:05 PM

I'm not sure I understand what you mean, either by indicating progress (progress of what) or by data bar (do you mean an Excel2010 Spark line?)

Feb 8, 2011 at 9:11 AM

No not a spark line. I want to use the data bar conditional formatting on a cell containing a percentage.

Under the conditional formatting menu in excel there is a data bars section above the color scales which adds a "progress bar" in the cells as a background.

Feb 8, 2011 at 9:51 AM

I don't know what version of Excel this was introduced in, but I wasn't aware of it, and unfortunately PHPExcel isn't either.

Feb 8, 2011 at 9:52 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.