count number of cell that contain red text

-

 

Step 1: Open the VBA Editor

  1. Press Alt + F11 to open the VBA editor.
  2. In the editor, go to Insert > Module.

Step 2: Add the VBA Code

Paste the following code into the module:

Function CountRedText(rng As Range) As Long
    Dim cell As Range
    Dim count As Long
    count = 0

    For Each cell In rng
        If cell.Font.Color = RGB(255, 0, 0) Then ' Check for red text
            count = count + 1
        End If
    Next cell

    CountRedText = count
End Function

Step 3: Use the Function in Excel

  1. Close the VBA editor (Alt + Q).
  2. Go back to your worksheet.
  3. In a blank cell, enter the formula:
=CountRedText(A10:A190)


Comments

Post a Comment

Popular posts from this blog

Basic Web Design with HTML and CSS

-
Image
Webpage A  web page  or  webpage  is a document, commonly written in  HTML , that is viewed in an Internet  browser . A web page can be accessed by entering a  URL  address into a browser's  address bar . A web page may contain text, graphics, and  hyperlinks  to other web pages and files.   WebSite : A website is a collection of several web pages. These pages are linked together with hyperlinks. A website has a unique domain name, and we can access it by entering that domain name in the URL. A domain name is a string of characters that identifies a website. It is what users type in their browser to visit your site.   Web hosting is a service that provides space on a server for your website files, allowing it to be available on the internet. When visitors access your domain name, the hosting provider will transfer those files to their web browsers.   Two types of website Static website ...
Read more

Project Web Design Assignment

-
Image
  Assignment-3 <!DOCTYPE html> <html lang="en"> <head>     <meta charset="UTF-8">     <meta name="viewport" content="width=device-width, initial-scale=1.0">     <title>Employee Information Form</title> </head> <body>     <div style="width:30%; margin: auto;">         <form action="#" method="POST">             <fieldset>                 <legend>Employee Details</legend>                                 <!-- Name Field -->                 <label for="name">Name:</label>                 <input type="text" id="name" name="name" required><br><br>           ...
Read more