How to change cell formatting on ther basis on negative and positive numbers

[Ishan_Shelke]

So I have a column like this in a Excel

My condition is where ever there are negative numbers in the column the text of that cell should turn green and if postive then it should be red Somewhat like this if 0 then no color (default black) and the cells where there are no values those should be ignored

[Kaviyarasu_N]

Hi @Ishan_Shelke

use the “Format Cell” activity in a UiPath workflow:

1. First, add the “Format Cell” activity to your workflow and specify the cell or range of cells that you want to format.
2. Next, select the formatting options that you want to apply. You can choose from a variety of options, including font size and type, alignment, borders, and fill color.
3. Once you have selected the formatting options that you want to apply, you can execute the activity to apply the formatting to the specified cells.

For more info: https://docs.uipath.com/activities/lang-en/docs/format-range-x

Regards,
Kaviyarasu N

[mohiniganesh15]

Hi Users ,

Read the Entire excel and use if condition and search for Negative numbers ,
and after that by using Set range color color as per your conditions …
for reference go through below video

UiPath Tutorial | Set the Color in Cell UiPath | Lookup Data Table UiPath | ExpoHub - YouTube…

mark as solution if it is helpful lets other get advantage …

Happy Automation…!!!