<div>
Trusting that you have two equal signs in each cell:<br />
<br />
&nbsp; &nbsp; Dim v<br />
&nbsp; &nbsp; Dim r As Integer<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; Const c = 1<br />
&nbsp; &nbsp; For r = 1 To ActiveSheet.UsedRange.Cell<wbr />s.Count<br />
&nbsp; &nbsp; &nbsp; &nbsp; v = Split(ActiveSheet.UsedRang<wbr />e.Cells(r,<wbr /> c), &quot;&nbsp;= &quot;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; If UBound(v) &lt;&nbsp;2 Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ActiveSheet.UsedRange.Cell<wbr />s(r, c).Interior.ColorIndex = 3<br />
&nbsp; &nbsp; &nbsp; &nbsp; End If<br />
&nbsp; &nbsp; Next r<br />

</div>


Trusting that you have two equal signs in each cell:

    Dim v
    Dim r As Integer
   
    Const c = 1
    For r = 1 To ActiveSheet.UsedRange.Cells.Count
        v = Split(ActiveSheet.UsedRange.Cells(r, c), " = ")
        If UBound(v) < 2 Then
            ActiveSheet.UsedRange.Cells(r, c).Interior.ColorIndex = 3
        End If
    Next r


<div>
Each Cell does not have only two equal to signs there must be atleast one and any number greater than one. We should also check that each cell in that column has an equal to present aso.
</div>


Each Cell does not have only two equal to signs there must be atleast one and any number greater than one. We should also check that each cell in that column has an equal to present aso.

<div>
<div class="content wysiwyg-content">
I have a column in a spreadsheet in which the cells will have value one of the following :<br />
m = male,f = female<br />
m = male^f = female<br />
Note that there is space after and before equal to sign.<br />
I need a macro which will check for all the cells in the column so that there is space after and before equal to sign. If a space is not there then that cell should be colured in red.
</div>
</div>


I have a column in a spreadsheet in which the cells will have value one of the following :
m = male,f = female
m = male^f = female
Note that there is space after and before equal to sign.
I need a macro which will check for all the cells in the column so that there is space after and before equal to sign. If a space is not there then that cell should be colured in red.

excel macro needed

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.