Use Visual Basic To Highlight Cells - Highlight A Range and The Active Cell With Shape Buttons
Highlighting cells can be automated to get your report out faster with macros. Use this code below to add to your macros to highlight data. Additionally, the macro can be attached to a button or shortcut key to run to highlight data in a new report.
======== CODE ========
Sub HLRange()
Selection.Interior.Color = vbRed
End Sub
Sub HLAC()
Active.Cell.Interior.Color = vbRed
End Sub
===== CHAPTERS =====
00:00 Start
00:57 Open A Module
01:22 Add VB Code
03:19 Inserting A Shape
04:17 Assign Macros
04:38 Test & Debug
======== TAGS ========
#msexcel #excel #excelmacro #excelvba #exceltutorial #highlight #excelformatting