How to check the color of the cell using VBA?
 
   Doing task automation? Struggled to find the color of the cell? Here is the way.......

 Steps:


 1. Press Alt + F11
 2. Insert->Module
 3. Write the below simple code


Sub CheckColorOfTheCell()
MsgBox ThisWorkbook.Sheets("Sheet1").Range("T1").Interior.ColorIndex
End Sub


Thanks,
Raegle