How to get time range

[postwick (Paul)]

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…