Aug 10 2021 09:06 AM
I've setup conditional formatting on a shared excel sheet where people can edit that file at the same time, but time stamp I setup to occur automatically when one of the column cell value is filled, it will not display on everyone’s spreadsheet and the highlighted rows supposed to highlight after the cut off time also is not display in the SharePoint version. As the creator when I open the file, everything is there for me to view.
Is there a way to make it appear on all the shared users' spreadsheet? Please help. Thank you.
Aug 10 2021 09:50 AM - edited Aug 10 2021 09:50 AM
If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!
Please include the following info to help others answer your question: Click on the Link
Welcome to your Excel discussion space!
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Aug 10 2021 09:53 AM
Aug 10 2021 10:07 AM
Aug 10 2021 10:39 AM - edited Aug 10 2021 10:41 AM
As you can also read in the link, please add an Excel file (without sensitive data) and describe your plan on the basis of this.
Sorry for the inconvenience, but the more information is shared, the better and faster a suggested solution can be submitted.
Please understand that I am not the most suitable to propose a solution to you.
But with my suggestions, I would like you to be able to get a possible solution from the specialists as far as possible, without which I can guarantee this for you.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
Aug 10 2021 10:45 AM
Aug 10 2021 11:01 AM
You can attache a samble if you click first
Examples of common formulas in lists
List and library column types and options
Use column formatting to customize SharePoint
Thank you for your patience and understanding
and hope that you will be offered a solution that fits your problem quickly.
I also wish you a lot of fun with Microsoft products.
We cannot do great things - only small ones, but those with great love.
Mother Teresa©
Nikolino :)
Aug 10 2021 11:13 AM
Aug 10 2021 11:51 AM
Aug 10 2021 12:05 PM
Aug 10 2021 12:09 PM
Aug 10 2021 12:36 PM
Hi @Cambosity100, yes this is protected. I do not want anyone to modify this sheet while entering the data. I did test it out with unprotected as well and it is display the same. I don't think it has to do with protected or unprotected.
Aug 10 2021 12:48 PM
Aug 10 2021 01:05 PM
Aug 10 2021 01:12 PM
Aug 10 2021 01:14 PM
Aug 16 2021 11:48 AM