If there are differences, transcribe and color flow

Like (0) Share

Report

Posted on 1 Sep 2023 22:29:14 by botamoti

Compare column A in the A excel file with column A in the B excel file. If there is a difference, transcribe the information from the A excel file to the B excel file. I need to know how to color the cells in the transcribed B excel file.

All responses (1)

Answers (0)

Nived_Nambiar 17,929 Super User 2025 Season 2 on 02 Sep 2023 at 03:02:51

Like (0)

Report

Re: If there are differences, transcribe and color flow

Hi @botamoti

to color a cell use the below office script which needs input the cell address which needs to be colored.

/**

* This script sets the fill color of the used range to a color.

*/

function main(workbook: ExcelScript.Workbook, celladdress: string) {

    // Get the used range of the current worksheet.

    let currentSheet = workbook.getActiveWorksheet();

    let usedRange = currentSheet.getRange(celladdress);

    // Get the RangeFill object.

    let fill = usedRange.getFormat().getFill();

    // Set the fill color to green.

    fill.setColor("yellow");

}

Use action in power automate to do this

Currently office script change the cell color to yellow, you can change that accordingly as per your requirement.

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌