two column conditions

  1. J

    Count DISTINCT in ColumnA IF ColumnE status='QA'

    Count DISTINCT in ColumnA IF ColumnE status='QA' I want to have a new column (RESULTS) where the formula counts only ColumnA (DISTICNLY) IF ColumnE cell = 'QA' Small example: Category Status RESULTS blue QA 3 <=== ONLY 3 DISTINCT Catgories that have status='QA' blue QA blue no...
  2. D

    How to make cells in one column change fill colors base off of two conditions

    Hello, I am looking to have a column of dates (column G) fill GREEN based off the conditions: 1. If there is a "P" (stands for portables) in column F 2. If the date listed in column G is over one year old (365 days+) I am also looking to have the same column of dates (column G) turn GREEN...
    • dstimpson
    • Thread
    • cell color fill colors dates two column conditions two conditions
    • Replies: 2
    • Forum: Excel Questions

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
Back
Top