According to the excel color ,how to get the position

i hava a question,there is a excel,the data is dynamic,

  1. i convert to a dataTable according to the excel
  2. i want to get the position with red color, to modify the data in dataTable
  3. how to deal this problem
    thank you
1 Like

hello @pathlearnjobboy
I didn’t find an activity to do it directly, but you can retrieve all the cells with a certain color by automating these steps:

  1. Press Ctrl+F to display the Find tab of the Find and Replace dialog box. …
  2. Make sure there is nothing in the Find What box.
  3. Click Format. …
  4. Make sure the Patterns tab is displayed. …
  5. From the colors available, choose the color you want to find .
  6. Click OK to close the Find Format dialog box.
  7. Click Find All .

every cell with color ,the cell data is different