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
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.
Im also aware that it can be done in xlsx. Was looking out for a way to achieve it using a csv
When you save the file as csv, then you are not able retain color.