We have a range of data and selected transactions have been highlighted with a cell fill color, as shown below. Objectiveīefore we get too far, let’s have a look at what we are trying to accomplish. This post provides three steps to workaround this issue and compute a total based on fill color. That means that functions such as SUM and SUMIFS operate on the underlying cell values and disregard cell formatting, such as font or fill color. If you need to compute the total for certain cells based on their font or fill color, you may have noticed that Excel formulas operate on stored values, not displayed values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |