This procedure formats cells in an Excel worksheet. You can set background color, font color, font weight, and font size for the specified cells.
Prerequisite Data
These required data elements must be present in the automation before using the procedure.
Data Name
Data Type
the excel
Excel File
Syntax
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
format the excel
What does it do?
References an Excel file to apply color formatting to.
Where does it go?
This phrase should be written on a new line.
Is it required?
✅ Yes — This phrase is required in the syntax.
Does it require input data?
⛔ No — This phrase does not require input data.
the worksheet name is
What does it do?
Specifies the name of the worksheet to modify.
Where does it go?
This phrase should be indented beneath format the excel.
Is it required?
✅ Yes — This phrase is required in the syntax.
Does it require input data?
✅ Yes — A Text value should be specified.
the cell range is
What does it do?
Specifies the range of cells to color (e.g., "A1:B10" or "A1").
Where does it go?
This phrase should be indented beneath format the excel.
Is it required?
✅ Yes — This phrase is required in the syntax.
Does it require input data?
✅ Yes — A Text value should be specified.
the bg color is
What does it do?
Specifies the background color in hex format (e.g., "FF0000" for red).
Where does it go?
This phrase should be indented beneath format the excel.
Is it required?
🌟 No — This phrase is optional in the syntax.
Does it require input data?
✅ Yes — A Text value should be specified.
the font color is
What does it do?
Specifies the font color in hex format (e.g., "0000FF" for blue).
Where does it go?
This phrase should be indented beneath format the excel.
Is it required?
🌟 No — This phrase is optional in the syntax.
Does it require input data?
✅ Yes — A Text value should be specified.
the font weight is
What does it do?
Specifies the font weight (e.g., "bold", "normal").
Where does it go?
This phrase should be indented beneath format the excel.
Is it required?
🌟 No — This phrase is optional in the syntax.
Does it require input data?
✅ Yes — A Text value should be specified.
the font size is
What does it do?
Specifies the font size in points (e.g., 12, 14, 16).
Where does it go?
This phrase should be indented beneath format the excel.
Is it required?
🌟 No — This phrase is optional in the syntax.
Does it require input data?
✅ Yes — A Number value should be specified.
Examples
1. Apply Background and Font Color
format the excel
the worksheet name is "Sheet1"
the cell range is "A1:C5"
the bg color is "FFFF00"
the font color is "000000"
the font weight is "bold"
2. Apply Font Size and Color
format the excel
the worksheet name is "Sheet1"
the cell range is "A1:A10"
the font size is 14
the font color is "0000FF"
