I have a spreadsheet with extensive conditional formatting in two of the sheets.
When I upload to Google Drive, all of the conditional formatting in the first sheet has disappeared, but the formatting in the second sheet is still there.
I tried recreating the formulas within Google Drive, but they get rejected as 'invalid formulas' even though I've copied and pasted from the second sheet.
Any ideas how I can get the conditional formatting to retain when uploading to Google Drive?
It sounds like you are trying to get EXCEL formulas to work in Google Sheets... which is NOT Google Drive.
It would be a lot easier to work out the solution if you can provide an excel file that we can upload and convert and find out what is breaking.
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks