Grab Highlighted or Coloured Cells in Excel

Hi squad,

any proposed solutions to differentiate cells that are highlighted/conditionally formatted and aren’t?
image
for example, I want to grab the values that are in purple, but not the ones that don’t have any highlights/background colours.

Hi Martina.
You cannot do it via Excel actions, there is no such functionality. But you can try to filter necessary rows in Excel and then grab your data to variables. To do it, you need to open Excel with Launch application, not with Open spreadsheet action.

1 Like

Ah, that’s too bad. Thanks for the info, however!

Hi @martina_r perhaps, this custom action can be helpful in your case