Checking color in excel usnig VBA Macro

Help Automation Suite
,
1

i want to check the color in the excel sheet if the color matches in multiple cell i want the list of cell range as an output.
@Yoichi @Anil_G

3

@Dinesh_Guptil,

How your excel looks like and what colum or range you want to check also which colour. Please give the context about the requirements.

4

The image shows a column in a spreadsheet titled "Color" with five cells filled with green. (Captioned by AI)
image

The excel looks like above i want to check the whole excel sheet and get the cell ranges of green color

5
  1. First you get total row of the excel sheet
  2. Second loop each row and get the color index from specific cell using GetColor = r.Interior.ColorIndex
  3. then loop each cell of the row see if r.Interior.ColorIndex = GetColor