Forum Discussion

Regular Contributor

5 years ago

Solved

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.

Marsha_R
Champion Level 3
5 years ago
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
Champion Level 2
5 years ago
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
- sonya_m
  Alumni
  5 years ago
  Thank you Alex, Marsha!
  
  whuang Please mark the best reply as a solution here!