Solved: Anyway to highlight Excel cell background to a dif...

whuang · ‎03-11-2021

Hi again,

Does anyone know if it is doable to highlight a cell background color through TC, and how I can do that?

Thanks in advance.

Marsha_R · ‎03-11-2021

Record a test and walk through the steps in Excel manually and see what code you get in TC. You might have to change it from using coordinates to using the cell object name but that should get you close.

AlexKaras · ‎03-15-2021

Hi,

Yes, this is doable with the help of Excel's COM object model.

https://www.google.com/search?q=excel+COM+vbscript+change+cell+background

Regards,
/Alex [Community Champion]
____
[Community Champions] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Champions]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Champion] signature is assigned on quarterly basis and is used with permission by SmartBear Software.
https://community.smartbear.com/t5/Community-Champions/About-the-Community-Champions-Program/gpm-p/252662
================================

sonya_m · ‎03-23-2021

Thank you Alex, Marsha!

@whuang Please mark the best reply as a solution here!

Sonya Mihaljova
Community and Education Specialist

USER PROGRAMCalling all Zephyr Scale users to become a Community All-Star

Anyway to highlight Excel cell background to a different color through TC?

Anyway to highlight Excel cell background to a different color through TC?

The object "textboxJUsername" does not exist

Regarding URL change in Existing keyword recording

Test Complete: why does the auto-wait timeout valu...

Excel Overlap Issue

TestComplete no longer record my test