Answered

Entering formula in Excel Formatting Rule

(0) Share

Report

Posted on by niken

Hello,

I'm using Power Automate Desktop to reset formatting and validation rule setup in a shared excel file located in MS Teams because when people copying & paste it will break those rules. I have very limited VBA knowledge and find Power Automate is more user friendly.

I encountered problem that Excel will automatically add the table range in the formula (data is set as table in the worksheet). Even when I stored the formula as variable it will keep on adding the table range in front of it.

Thank you

Categories:

Power Automate Desktop

All responses (3)

Answers (1)

Sort by

niken 7 on at

Like
a
(0)

Report
Copy link

Link copied!

I recreated another PAD with data not set as a table and change the formula to avoid using <">, but it still adds range of cells in front of the formula. Should I move this to "Found Bug"?
Verified answer

MichaelAnnis 5,727 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

No. That is there automatically, instead do this:

mouse click on text field
send keys {Control}(a){Delete}
then send keys for your formula

that should clear out the other stuff before pasting your formula in there.

good luck!
niken 7 on at

Like
a
(0)

Report
Copy link

Link copied!

works like a charm..thank you so much MichaleAnnis