Excel Tutorials | Formatting macros Codes

Sub highlightUniqueValues() Dim rng As Range Set rng = Selection rng.FormatConditions.Delete Dim uv As UniqueValues Set uv = rng.FormatConditions.AddUniqueValues uv.DupeUnique = xlUnique uv.Interior.Color = vbGreen

Sub columnDifference() Range(“H7:H8,I7:I8”).Select Selection.ColumnDifferences(ActiveCell).Select Selection.Style= “Bad” End Sub Using this code you can highlight the difference between two columns (corresponding cells).

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim strRange As String strRange = Target.Cells.Address & “,” & _ Target.Cells.EntireColumn.Address & “,” & _

Sub rowDifference() Range(“H7:H8,I7:I8”).Select Selection.RowDifferences(ActiveCell).Select Selection.Style= “Bad” End Sub You can Highlight Difference in Rows (corresponding cells) by using this VBA Macro Code in Excel

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim strRange As String strRange = Target.Cells.Address & “,” & _ Target.Cells.EntireColumn.Address & “,” & _

Highlight Duplicates from Selection Sub HighlightDuplicateValues() Dim myRange As Range Dim myCell As Range Set myRange = Selection For Each myCell In myRange If WorksheetFunction.CountIf(myRange,

Sub highlightCommentCells() Selection.SpecialCells(xlCellTypeComments).Select Selection.Style= “Note” End Sub To highlight all the cells with comments use this macro code