Conditional formatting errors in SharePoint

[Ronni f]

Happy Friday All,

I created a calendar in excel, stored in my OneDrive, and created conditional formatting. This changed the colour of a cell when a letter is typed.
When I upload this into SharePoint and try to type the letter into a cell - this auto fills the name of the day into that cell.
Example - I type 'M' for medical into cell Q20 it ads the word 'Mon' as that is in cell Q7.

I tried the ISBLANK formula but that didn't work either

 

[6StringJazzer]

It's not clear what you mean by "conditional formatting....changed the colour of a cell when a letter is typed." Do you mean it changes the color when the cell contains any letter? Or different colors for different letters? Or...? What is the actual conditional formatting rule? Is this relevant to your overall question?

It would help if your screenshot showed the row and column headings so we could tell what cells are Q7 and Q20.

When you start typing into a cell, Excel normally will autofill based on data that appears in cells above it in the same column. Are you saying this behavior does not happen if you open the file from your local hard drive, only from SharePoint? When you open an Excel file from SharePoint are you using your desktop Excel version, or the browser version of Excel? What version do you use on your local desktop computer?

One option I would consider is setting up Data Validation, List, with Dropdown to fill in those cells.

 

[Ronni f]

Hi, Thanks for the quick reply.

Here's the rules and the image with cell letters and numbers

Works fine in excel, just not when uploaded to SharePoint.

eg. in SharePoint when I try to type 'M; into cell R9 to turn it purple for a medical appointment, it auto fills with the word Mon.

Hope this helps explain a bit more

 

[6StringJazzer]

Works fine in excel, just not when uploaded to SharePoint.

Sorry but this doesn't make sense. SharePoint is just a file repository. If you are editing the file you are using Excel. You can either use Excel on your local computer, or you can use a browser-based version of Excel. If you are opening a file by clicking a link in SharePoint it is likely that you are using a browser-based version of Excel. If that is true then at the top of the screen you should see an option somewhere to open the file in your desktop version of Excel. I no longer have access to a SharePoint environment so I can't give details.

I explained why you are seeing this behavior although I don't know why it doesn't happen on your desktop version of Excel. The two versions do not behave identically. The best option is to add data validation as I suggested.