Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Countif coloring of cells that were used. [Closed]

Report
-
 Blocked Profile -
Hello,

I would like to color cells (or a row) that were used for "countif" values.

for example, at my work, i have to indicate private calls from my service phone among all my calls for specific month; further to that, i used following formula that calculates phone values based on my home country phone prefix (which are usually my private calls):
=SUMIF(F:F,"*386*",G:G)

further to that, i would also like that the values identified and used for calculation (either the cells or the whole row) would be marked with specific color.

I hope my question make sense.

thank you very much for your cooperation. Damian

1 reply

Answer 1 / 1

So, do you or do you not know about conditional formatting? Your statement wasn't clear on what you have already tried.
Report
Posts
1
Registration date
Tuesday April 4, 2017
Status
Member
Last seen
April 5, 2017
thanks! i know about it; i was just wondering if i can incorporate/add the coloring part into the existing countif formula (so both the telephone number and its value/amount would change color).

sorry, i know im probably complicating the issue unnecessarily.
Report
Blocked Profile
Yes, Just apply the same formula from the telephone, onto the amount, and Color it.

So, if your phone logic turns cell A1 red, then apply the same logic to B1 and both will turn!
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!