Tell me which activity to use to highlight a cell in Excel with a certain color?
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
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:
- Use the “Excel Application Scope” activity to open the Excel file and select the sheet where the cell you want to highlight is located.
- Use the “Read Range” activity to read the value of the cell you want to highlight.
- Use the “Set Range Color” activity to set the background color or the font color of the cell.