71%

  1. M

    How to Count or Sum cells with Colors

    Hi All, I have rows 1 thru 21, with data in column B. How would I count or sum the number of green cells? I have tried to google this and want to keep this simple, so I'm hoping I don't need to use VBA.... Sorry, I had colors on my spreadsheet, but when I copied it onto the body of my...
  2. nature969

    decision formula/ conditional formatting

    HI Ihave a set of data (see below). I want to count “YES” and the more “yes”supplier have the darker colour the result it should be ( in this way I canshow which supplier I should pick) Icouldn’t figure out a way. The only thing I can think about is percentage. Cananyone help me to find a...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top