Unanswered

PowerAutomate with Excel conditional formatting

(0) Share

Report

Posted on by kayal1s

Is it possible to color Excel rows using conditional formatting using PowerAutomate?

For example, I want to check some certain values in certain rows and after the conditional formatting is over, I want to color that row so that it will be highlighted.

If this is possible in PowerAutomate desktop or Online, please let me know the steps.

Regards,

Sayan

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

cchannon 4,702 Moderator on at

Like (0)

Report

Yes. You just set your conditional formatting up in the Excel sheet before the Power Automate run, then let the values populated by Power Automate Desktop immediately result in the correct formatting.

Was this reply helpful? Yes No
kayal1s 32 on at

Like (0)

Report

No actually I'm telling like- for example, I have an excel sheet and I want to color some of the columns by applying a condition in PowerAutomate. Is that possible?
NOTE: I've checked that PowerAutomate can detect conditions from any specific rows but the rows or the coloumns can be colored using PowerAutomate or not, that I don't know actually, can you please help me out in this regard?

Was this reply helpful? Yes No
JeffreyDSmith 69 on at

Like (0)

Report

The most reliable way that I perform actions in Excel by Power Automate Desktop (PAD) is using keyboard shortcuts with short WAIT statements to give the compute a chance to act on the SendKeys.

Was this reply helpful? Yes No
kayal1s 32 on at

Like (0)

Report

Can you please guide me a little bit more with any screenshot or any link so that I can refer with? Actually I'm new to PowerAutomate desktop, and suppose I need to search some specific item name like 'Overtime', and for how many employees that's happening, I want PowerAutomate to sort all of them, and color them as per my choice, is it possible?

Was this reply helpful? Yes No
JeffreyDSmith 69 on at

Like (0)

Report

Here are two small sample files of flows that I use to control Word and Excel. I had to post them .docx format because .txt format is unsupported. They use Power Automate Desktop (PAD) to send keys and mouse clicks to the Word or Excel open application. They are part of my larger flow system, so they may not make much sense on their own. Convert them to .txt format, and then create the flow by copy & paste into the PAD editor. Use the file name (without the extension) for the flow name. Open Excel and then run the flow. You may need to enable the "Developer" tab on the menu ribbon in Word and Excel before running them. Study them to see how they use the mouse to activate the App and send keys to control the App.

For your flow, you will have to learn how to use keyboard shortcuts to do what you want in Excel, and than write your flow using the mouse controls and the send keys controls. I sprinkle small Wait statements to allow for computer latency.

Open Run Macro Re...

Mailmerge Timesta...

Was this reply helpful? Yes No
JeffreyDSmith 69 on at

Like (0)

Report

You can also watch all of my YouTube videos (they're over a year old by now) on using Power Automate Desktop (PAD) to run Word, Excel, and Adobe Acrobat with keyboard shortcuts. My software is freely downloadable. Here is an example:
ConvertLeaseOptionToWrapAround Tutorial Power Automate Upgrade CLOTWA Excel
https://www.youtube.com/watch?v=m9qDVyx1Szc

Was this reply helpful? Yes No