Register
SmartBear Support Resources
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Solved
Start a topic
whuang
Frequent Contributor
‎03-11-2021 11:36 AM
‎03-11-2021 11:36 AM

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

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.

0 Kudos
Reply
1 ACCEPTED SOLUTION

Accepted Solutions
AlexKaras
Community Hero
Community Hero
‎03-15-2021 06:43 AM
‎03-15-2021 06:43 AM

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

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 Hero]
____
[Community Heroes] 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 Heroes]
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 Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
================================

View solution in original post

Reply
3 REPLIES 3
Marsha_R
Community Hero
Community Hero
‎03-11-2021 02:08 PM
‎03-11-2021 02:08 PM

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

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.

Reply
AlexKaras
Community Hero
Community Hero
‎03-15-2021 06:43 AM
‎03-15-2021 06:43 AM

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

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 Hero]
____
[Community Heroes] 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 Heroes]
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 Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
================================

View solution in original post

Reply
sonya_m
Community Manager Community Manager
Community Manager
‎03-23-2021 04:22 AM
‎03-23-2021 04:22 AM

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

Thank you Alex, Marsha!

 

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


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
0 Kudos
Reply
New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors
View All