Excel Conditional Formatting

Question

How can i bold entire row in multiple sheets if cell text is grand total.&nbsp;please help because grand total row position in all sheets is different.

hansvogelaar · Answer

devyadav2008&nbsp;
Let's say the text "grand total" occurs in column A.
Select the entire range you want to format, or even all cells.
I will assume that the active cell in the selection is in row 1.
On the Home tab of the ribbon, select Conditional Formatting &gt; New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
&nbsp;
=LOWER($A1)="grand total"
&nbsp;
Remember, A is the column that will contain "grand total", and 1 is the row number of the active cell.
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.

devyadav2008 · Answer

Thank You Sir for your response...But this will be work in single sheet, I have to change multiple sheets which have grand total in column A

hansvogelaar · Answer

devyadav2008&nbsp;
You'll have to create a rule for each sheet. If you wish, you can do this with a macro.
&nbsp;
Sub AddCF()
    Dim w As Worksheet
    For Each w In Worksheets ' or Worksheets(Array("Sheet1", "Sheet2", "SheetC"))
        With w.Cells.FormatConditions
            .Delete
            .Add(Type:=xlExpression, Formula1:="=LOWER($A1)=""grand total""").Interior.Color = vbYellow
        End With
    Next w
End Sub
Change vbYellow to the color you want to use.

Forum Discussion

Excel Conditional Formatting

3 Replies