Manual Way To Find RGB Color Code
Select a cell that contains the fill color you want to look up.
Click the Paint Bucket button on your Home Ribbon tab.
Select the More Colors option.
Go to the Custom tab and make sure Color Model = RGB.
You will now see the RGB color code for your selected cell’s fill.
Arul not sheet name, that is just a input Arul or Kannan whatever input i give based on name column ,output is that name color only i want and that color to paste another excel or sheet but paste to minimum filled column
for example column 1—>Count is 5
Column 2—>Count is 6
Column 3—>Count is 3
So that color should apply least count value column 3 only count 3 so should paste color there only last cell of column 3
If suppose column 2 count is 2 means should paste column 2 last cell
Read the data into datatable use lookup to find the name and get the row
Function GetColorCell(Rgs as String) as String GetColorCell = CStr(Range(Rgs).Interior.Color) End Functionsave this as vba file ans use incoke vba…send the cell value as you got rowindex A+ rowindex.tostring…in return you will get the color
Now read the second data into another dt and loop through each row and loop theough each column and find the first empty value…if empty value found then check if the value already present is greater than first value and store the cell vaue…
Function GetColorCell(Rgs as String,colorindexval as string) Range(Rgs).Interior.Color= Cint(colorindexval) End Functionsave this as vba file ans use incoke vba…and send the cel vaue identified