Apr 30 2021 11:13 AM
I have an Excel Spreadsheet that two users use each day.
They do a LOT of ctrl C and ctrl V.
Because of this, it starts messing with the conditional formats we have.
My idea was to create a script inside of Excel Online, save it, then user Power Automate each night to run that script to fix all the conditional formats.
The script would delete the CFs from two sections of the sheet, and then recreate them.
I have zero idea how to write these scripts, so I was using the record actions feature.
It records me creating the CF, but when I run the script to test it, it always errors.
See attached.
What I am not understanding is I am not changing these scripts after I stop recording so I am not sure what is happening.
Goal:
Script the following:
Delete all rules in section J3:L55
Delete all rules in section M3:AG66
For section J3:L55, create a rule that highlights cells that have text like:
Sun-Wed
OO*
OFF*
Wed-Sat
Med*
etc..
For the other sections, I have a rule for each column that turns the cells black if a certain cell is a Weekend. The actual condition looks like this:
Apply to range M3:M55
=WEEKDAY(R2C13,2)>5
Then I do that for every other column (the C changes in the formula above).
When I try to create these with the recorder they are failing.
Apr 30 2021 11:33 AM
Apr 30 2021 01:51 PM
Apr 30 2021 03:49 PM