CODEWITHSUNDEEP
excel-formulahighlightcountif
smaqsood
smaqsood

Reputation: 1869

Color Excel cell based on COUNTIF function

I'm trying to color excel cell based on my COUNTIF-function. There are many examples to count cell based on color but i need to fill cell with color based on COUNTIF-function. I have 30 names in a column. At the end i have COUNTIF-function to count total number of names with last name Malik. This works and i get number 8 from this function. Now I would like to highlight these 8 cells, so they are easy to find. If colorfill can be combined with COUNTIF-function, it would be the best.

Upvotes: 0

Views: 740

Answers (1)

OverflowStacker
OverflowStacker

Reputation: 1348

conditional formatting -> formula -> =isnumber(search("Malik",a1;0)) should work. delete dollar signs for the search cell. Adapt the celladdress to your needs.

You could also use =COUNTIF(A1,"*Malik*") or even use =COUNTIFS(A1,"*Malik*",B1,"<"&today())

Upvotes: 1

Related Questions