website of cybergana

About CountCellsByColor:
Using CountCellsByColor you can count cells fiiled by color.

   Function CountColoredCells(rng As Range, clr As Range) As Long

Dim cell As Range

Dim count As Long

count = 0

  For Each cell In rng

      If cell.Interior.Color = clr.Interior.Color Then

  count = count + 1

    End If

Next cell

CountColoredCells = count

End Function

Process of Creating function of CountCellsByColor:

Requirments tools...

1. Develper mode should be add on formulabar.
2. How to on Develper mode. Click here go to video

Process :

Copy script commond and paste in develper-module.
Then write function name : CountCellsByColor Process:

Using VBA (Custom Function):

Open VBA Editor: Press Alt + F11.

Insert Module: Go to "Insert" > "Module".

Paste Code: Paste the following VBA code into the module:

Close VBA Editor: Return to Excel.

Use the Function: In a cell,

Use the formula =CountColoredCells(range_to_check, cell_with_target_color).

COUNTBLANK

About COUNTBLANK:
Using COUNTBLANK you can count Blank cell of selection area.

Process of COUNTBLANK:

1. Follow this guidlines and learn to better.
2. Follow my Youtube Channel and learn (Advance-excel) & Ethical Hacking and Web Designing.
3. Click here go to video

Additional Details

Here are to more Advance Formulas that can make your career in Data analystic Sector.

COUNTIF

About COUNTIF:
COUNTIF Formula counts a word or a specific number how many time comes in selected area.

Additional Details:

1. Follow this guidlines and learn to better.
2. Follow my Youtube Channel and learn (Advance-excel) & Ethical Hacking and Web Designing.
3. Click here go to video

COUNT

About COUNT:
COUNT Formula counts how many cells fill to number or word ..

Process of COUNT:

1. Follow this guidlines and learn to better.
2. Follow my Youtube Channel and learn (Advance-excel) & Ethical Hacking and Web Designing.
3. Click here go to video

COUNT

About COUNT:
COUNT Formula counts how many cells fill to number or word ..

Process of COUNT:

1. Follow this guidlines and learn to better.
2. Follow my Youtube Channel and learn (Advance-excel) & Ethical Hacking and Web Designing.
3. Click here go to video