Forum Discussion
Excel Conditional Formatting
How can i bold entire row in multiple sheets if cell text is grand total. please help because grand total row position in all sheets is different.
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
But this will be work in single sheet, I have to change multiple sheets which have grand total in column A
You'll have to create a rule for each sheet. If you wish, you can do this with a macro.
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 SubChange vbYellow to the color you want to use.