Countif coloring of cells that were used.

Closed
Damian - 4 Apr 2017 à 07:32
 Blocked Profile - 5 Apr 2017 à 15:59
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

Related:

1 response

Blocked Profile
4 Apr 2017 à 16:59
So, do you or do you not know about conditional formatting? Your statement wasn't clear on what you have already tried.
Damian2003 Posts 1 Registration date Tuesday 4 April 2017 Status Member Last seen 5 April 2017
5 Apr 2017 à 02:11
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.
Blocked Profile
5 Apr 2017 à 15:59
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!