Detcting the excel cell based on colour
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
22-11-16 11:56 AM
Hello all ,
How to detect color of a particular cell ,Say there is a row like test passed which is indicated in "green colour" and red is failed . Is there a way to spy or capture that colored cell in bp and validate. I was not able to find an color filtering option in excel vbo.
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
22-11-16 02:15 PM
Hi Iraj,
I think that such specific things in Excel are best handled by Visual Basic. So you can add a Code Stage an insert the relevant code.
