How to make a cell the right color?

Help Robot
,
1

Tell me which activity to use to highlight a cell in Excel with a certain color?

2

@sazonov038

You can use format cells activity

https://docs.uipath.com/activities/docs/format-range-x

Cheers

3

Hi @sazonov038 ,

You could try to use Set Range Color activity :

https://docs.uipath.com/activities/other/latest/user-guide/excel-set-range-color

Or In the Modern Design we also have the Format Cells Activity :

https://docs.uipath.com/activities/other/latest/user-guide/format-range-x

4

To highlight a cell in Excel with a certain color in UiPath, you can use the “Set Range Color” activity. This activity allows you to set the background color or the font color of a cell or a range of cells in Excel.

Here are the steps you can follow to use the “Set Range Color” activity to highlight a cell with a certain color:

  1. Use the “Excel Application Scope” activity to open the Excel file and select the sheet where the cell you want to highlight is located.
  2. Use the “Read Range” activity to read the value of the cell you want to highlight.
  3. Use the “Set Range Color” activity to set the background color or the font color of the cell.
5

Hi @sazonov038

Try to use modern Excel activities. Refer below screenshot

image
image543×507 17.6 KB

Reagrds,
Kaviyarasu N

6

Im facing a challenge here, once the cell is set to format the color to Red (which it is doing correctly) but as soon as it changes the color it is deleting the value from it.

Expected output

Results
————
Fail - Red
Pass - Green
Pass - Green

Getting the results
—————————
Results
————
- Red
Pass - Green
Pass - Green

Value is getting erased

I’m using the format cell modern activity