How to change text colour of excel cell? (Without Macros)

Help Something Else
,
1

I am using Write Range Activity to write Data Table to excel file. But I want to change the text colour of a column’s values to red and green depending on the value. Let’s say if the value is FAIL it should be red and if it is PASS then green. Need to perform this without macros.

2

Hey there,

Here is your logic ,

123.xlsx (9.5 KB)
Flowchart.xaml (13.3 KB)

3

It changes the cell colour

4

Hi ,

If it is with font color you can use hotkeys ,

–inside switch case , activate hotkeys with alt + H
–use hotkey “FC” for colors
–Use M for more colors
– Enter Color code for red or green
– use click activity to click on Ok

Hope this works

5

Okay. Thanks. Is there any other approach. Like using invoke code or using vb methods