Excel Automation flagging dates that are outside start and end dates

Hi!
On my excel worksheet, I have 2 dates start-(1/1/2020) and end-(31/3/2020)

I also have a table containing random dates. Is there any way to highlight/flag all dates that are outside my date range using UiPath?

Any help would be much appreciated! Thank you!

Hi @h2000

Welcome to forum

Can u share the sample excel file data so that we can try ?

Dates.xlsx (11.7 KB)

Hello!

Please find attached! As I was explaining earlier, since 4/4/2020 and 7/8/2020 are outside of the start and end dates, they need to be highlighted!

Thank you so much for all your time!

Hi @h2000
I think the result u need is finally like this

Refer this workflow : Main.xaml (15.4 KB)

Hope u got answer to ur query

Mark it as solution if it helps

Regards

Nived N
Happy Automation

Download and run the attached code.
Highlightcells_temp.zip (32.8 KB)

Hope this helps.

Happy to help understand the logic in case any doubt. change file path, cell reference to match with actual data :slight_smile:

Thank you @NIVED_NAMBIAR and @mohammedsameer.ali1! Both solutions are working perfectly!!

:slightly_smiling_face:

Best Regards,
h2000

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