This video explains how to select a range of cells and perform various operation like Merge, Unmerge, Copy, Coloring the selected range.
Below is the link for colorIndex.
https://docs.microsoft.com/en-us/offi...
#PowerShell
#ExcelAutomation
#ExcelWithPowerShell