Hi bharadwaj813,
Refer the section '
How to set the FillColor to a cell:' in the below link.
http://rpaforum.net/threads/excel-cell-color-identification.1039/post-3087
The above link is for Fill Color.
For Font color the only difference is to use the below line of code instead.
Code:
GetWorkbook(handle,Nothing).ActiveSheet.Range(cellref,cellref).Font.Color = RGB(Red_Value, Green_Value, Blue_Value)
In the above case you need to separately pass the columns with a new Action stage.
eg; A:B
Then again a new Action stage for D column.
But if you want to have a single stage and pass all the required columns at once then use the below line of code
GetWorkbook(handle,Nothing).ActiveSheet.Range
(cellref).Font.Color = RGB(Red_Value, Green_Value, Blue_Value)
Now you can pass multiple consecutive or non consecutive columns as below.
View attachment 899
and only A, B and D columns will have the new Font color.
View attachment 900
You can also pass row numbers.
For example; when you pass Cell Reference parameter as below,
View attachment 902
then the result will be as below.
View attachment 901