Want to apply color in my excel file.

(0) Share

Report

Posted on by Shagoul

110

Hi Everyone,

I need some help applying background color when the share point list is modified.

I’ve flow if any item is modified in the share point list, then I will add that item into a new excel file. This is working fine please refer flow below.

if suppose a user has modified ID1 (4) status column = “fail “ then I want to be highlighted with some color in my excel file.

Example excel output am looking for:

Sharepoint list:

MS FLOW:

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@Shagoul

In Excel, add a column for the update date and populate the column when the row of data is added. Then, I believe you can use the Excel conditional formatting feature to show it in yellow if the update day is today.....

I am not aware of any way of meeting your goal with Power Automate.

Was this reply helpful? Yes No
Shagoul 110 on at

Like (0)

Report

Hi Scott,

Thanks for the response can you please share any references that would be help full.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@Shagoul

first, add a column to the table for your date. Then select the column that you want to format.

Here is a screen shot of the conditional formatting rule that I created:

Was this reply helpful? Yes No
Shagoul 110 on at

Like (0)

Report

Hi Scott,

Thanks for the response
Let me try and get back to you soon

Was this reply helpful? Yes No
Shagoul 110 on at

Like (0)

Report

Unfortunately, my requirement is not full fill with this way 😞

There are 20 columns then if only one column is is modified then that cell should be highlighted automatically with some color is there any other solution please advise.

Was this reply helpful? Yes No