Highlight csv cell

Can we highlihgt a cell color in a csv file? Im trying to highlight a cell color in a csv file by using the csv file under excel app scope, I am not able to save the file. Bot is able to highlight the cell, but its not getting saved when I open it after the run. Tried sending hotkeys and clicking the save icon, it doesnt seem to work

Hi @shreyaank,

As far as I am aware, You will not be able to color the cell in CSV and save it as .CSV file.

When you open a csv with excel you can color the cell but when you save it as csv, the color and other excel features wont reflect as you are saving it as CSV.

You can achieve the same in .xlsx format. Hope it helps.Mark it as solution.

Happy Automation!!!

Warm Regards,
Ranjith Udayakumar

1 Like

Im also aware that it can be done in xlsx. Was looking out for a way to achieve it using a csv

Hi @shreyaank,

When you save the file as csv, then you are not able retain color.

Warm Regards,
Ranjith Udayakumar