How to get time range

[Himani_Rautela]

I have two sheet one sheet for the outrage change start and end and other sheet is time coloumn for the outrage start time and end , what logic i can apply to get time from the change sheet and fill the color in that time coloum range … for change outrage start from 20 june 2024 16:00:00 to 22 june 2024 08:00:00 , so i need to fill the color in cell from 16:00:00 to 08:00:00

[SenzoD (Senzo Dlomo)]

Hi there,

can you share a sample file?

[pravallikapaluri]

Hi @Himani_Rautela
Can you share the expected output file also.

[postwick (Paul Ostwick)]

It’s good to search the forums before posting, there are lots of posts on setting cell color in Excel.

How to format cells based on their value (ie negative numbers in red)

This was done using UiPath.Excel.Activities 2.16.2 - it may work with older versions, I don’t know when these activities were introduced. It likely works with newer versions also. This particular code I’m showing sets negative numbers to red, but you could of course also put a Format Cells activity into the Then block to format positive numbers green, for example. Basic steps: Excel Process Scope Use Excel File – For Each Excel Row — If to determine positive or negative ---- Format Cell…

[Himani_Rautela]

Hello Postwick
Thanks for the reply, but how it will detect like the outrage time , i need logic where it automatically detect the date and for that date and outrage time it will fill color.

[postwick (Paul Ostwick)]

For Each Excel row and do your calculation for each row, setting the color depending on the value of the calculation.