How do i check If any red color under any columns

Help Studio
, ,
1

Hi All

How do I check If any red color under any columns in excel and send mail notification

How to approach this

Regards
Sachin

2

have you tried using Get cell color activity?

3

No not yet

Not getting any idea how to approach this

4

I was gotta make the example but someone already showed here =>

  • Use Excel Scope
  • Read range
  • For each excel dt row
  • Use get cell color
  • if the excel cell color is red then send an email else do nothing
1 Like
5

Hello @Sam_H

You can check the below. If you need to make it dynamic, you can use a for each row in excel and then use the Get Cell Color activity.

Thanks

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.