The way to Depend Coloured Cells in Microsoft Excel

This information is about The way to Depend Coloured Cells in Microsoft Excel. So learn this free information, The way to Depend Coloured Cells in Microsoft Excel step-by-step. If in case you have question associated to similar article it’s possible you’ll contact us.

The way to Depend Coloured Cells in Microsoft Excel – Information

Whereas coloured cells are a good way to spotlight information to get somebody’s consideration rapidly, they’re not a good way to retailer information. Sadly, many customers colour a cell to point out a worth as a substitute of making one other information level with the worth. For instance, as a substitute of making one other information level with the textual content Accredited, they’ll colour a cell inexperienced to point that an merchandise has handed. This causes loads of issues when you actually need to learn how many articles have been authorized. Excel doesn’t present a built-in technique to depend coloured cells. Click on the small down arrow on Format button and select Select Cell Format.

Clicking on the Format Physique button opens the Discover Format menu the place you possibly can choose any mixture of formatting to go looking. That is good if you realize precisely what colour you’re on the lookout for, nevertheless it’s normally best to specify the format from an instance. The underside of the Discover and Substitute dialog will present you all discovered cells that match the formatting, and on the underside left you’ll discover the depend.

Excel Depend Coloured Cells Utilizing AutoFilter Possibility

For this instance, take a look at the info beneath. As we will see, every metropolis is marked with totally different colours. So we have to depend the variety of cities based mostly on the cell colour. Observe the steps beneath to depend cells by colour.

Observe the steps beneath to depend cells by colour

  • Apply the filter to the info.
  • On the backside of the info, apply the SUBTOTAL perform in excel to depend cells.
  • The SUBTOTAL perform incorporates many formulation; that is helpful if we wish to depend, sum, common solely seen cell information. Now, beneath the “PIN” heading, click on on the drop-down checklist filter and choose Select by colour.
  • As we will see, all the colours within the information. Now select the colour you wish to filter on.
  • Excel depend coloured cells utilizing VBA code

    VBA avenue good strategies assist us to scale back time consumption in our office for a number of the tough issues.

    Not solely can we cut back the time, however we will additionally create our personal capabilities to go well with our wants. Considered one of these capabilities we will create a perform to depend cells based mostly on colour. Under is the VBA code to create a perform to depend cells based mostly on colour.

  • The primary line of the “Color_Cell_Count” code is the title of the perform. Now create three cells and colour them like beneath.
  • Now open the “Color_Cell_Count” perform in cell G2.
  • Although we don’t see the syntax of this perform, the primary argument is the colour we have to depend, so choose cell F2.
  • The second argument is to pick out the cell vary as D2:D19.
  • Shut the assist and hit the enter key. It will give the depend of cells which have the colour of the chosen cell.
  • Excel Depend Coloured Cells Utilizing the FIND Methodology

    We are able to additionally depend cells based mostly on the FIND methodology.

  • First, choose the vary of cells the place we have to depend cells.
  • Now press Ctrl + F to open the FIND dialog.
  • Now, click on on “Choices>>.”
  • It’ll develop the FIND dialog field. Now click on on the “Format” choice.
  • Now it can open up the “Discover Format” dialog field. Click on on the “Select cell format” choice.
  • Now, simply transfer the mouse pointer to see the pointer to pick out the format cell in Excel that we need to depend.
  • Choose the cell that’s formatted as the specified cell depend. I selected cell F2 as the specified cell format and now I can see the preview.
  • Now click on on FIND ALL choice to get the chosen cell format depend.
  • Ultimate observe

    I hope you just like the information The way to Depend Coloured Cells in Microsoft Excel. In case in case you have any question regards this text it’s possible you’ll ask us. Additionally, please share your love by sharing this text with your pals.

    Similar Posts

    Leave a Reply

    Your email address will not be published.