Having problem display conditional formating and time stamp on a shared excel sheet.

%3CLINGO-SUB%20id%3D%22lingo-sub-2632809%22%20slang%3D%22en-US%22%3EHaving%20problem%20display%20conditional%20formating%20and%20time%20stamp%20on%20a%20shared%20excel%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2632809%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20setup%20conditional%20formatting%20on%20a%20shared%20excel%20sheet%20where%20people%20can%20edit%20that%20file%20at%20the%20same%20time%2C%20but%20time%20stamp%20I%20setup%20to%20occur%20automatically%20when%20one%20of%20the%20column%20cell%20value%20is%20filled%2C%20it%20will%20not%20display%20on%20everyone%E2%80%99s%20spreadsheet%20and%20the%20highlighted%20rows%20supposed%20to%20highlight%20after%20the%20cut%20off%20time%20also%20is%20not%20display%20in%20the%20SharePoint%20version.%26nbsp%3B%20As%20the%20creator%20when%20I%20open%20the%20file%2C%20everything%20is%20there%20for%20me%20to%20view.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20make%20it%20appear%20on%20all%20the%20shared%20users'%20spreadsheet%3F%26nbsp%3B%20Please%20help.%26nbsp%3B%20Thank%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2632809%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2632899%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20problem%20display%20conditional%20formating%20and%20time%20stamp%20on%20a%20shared%20excel%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2632899%22%20slang%3D%22en-US%22%3EIf%20you%E2%80%99re%20looking%20to%20ask%20a%20question%20or%20start%20a%20conversation%20about%20Excel%2C%20you%E2%80%99re%20in%20the%20right%20place!%3CBR%20%2F%3EPlease%20include%20the%20following%20info%20to%20help%20others%20answer%20your%20question%3A%20Click%20on%20the%20Link%3CBR%20%2F%3EWelcome%20to%20your%20Excel%20discussion%20space!%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20understanding%20and%20patience%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%3CBR%20%2F%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2632902%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20problem%20display%20conditional%20formating%20and%20time%20stamp%20on%20a%20shared%20excel%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2632902%22%20slang%3D%22en-US%22%3EThank%20you%20Nikolino.%20I%20will%20do%20that%20right%20now.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2632983%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20problem%20display%20conditional%20formating%20and%20time%20stamp%20on%20a%20shared%20excel%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2632983%22%20slang%3D%22en-US%22%3EThe%20shared%20sheet%20is%20running%20on%20Window%2010%20Prof.%20plateform.%3CBR%20%2F%3EMicrosoft%20Excel%20for%20Microsoft%20365%20MSO%20(16.0.14228.20216)%2064-bit%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2633072%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20problem%20display%20conditional%20formating%20and%20time%20stamp%20on%20a%20shared%20excel%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2633072%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20you%20can%20also%20read%20in%20the%20link%2C%20please%20add%20an%20Excel%20file%20(without%20sensitive%20data)%20and%20describe%20your%20plan%20on%20the%20basis%20of%20this.%3CBR%20%2F%3E%3CBR%20%2F%3ESorry%20for%20the%20inconvenience%2C%20but%20the%20more%20information%20is%20shared%2C%20the%20better%20and%20faster%20a%20suggested%20solution%20can%20be%20submitted.%3CBR%20%2F%3EPlease%20understand%20that%20I%20am%20not%20the%20most%20suitable%20to%20propose%20a%20solution%20to%20you.%3CBR%20%2F%3EBut%20with%20my%20suggestions%2C%20I%20would%20like%20you%20to%20be%20able%20to%20get%20a%20possible%20solution%20from%20the%20specialists%20as%20far%20as%20possible%2C%20without%20which%20I%20can%20guarantee%20this%20for%20you.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20patience%20and%20time.%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%3CBR%20%2F%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2633076%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20problem%20display%20conditional%20formating%20and%20time%20stamp%20on%20a%20shared%20excel%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2633076%22%20slang%3D%22en-US%22%3EHi%20Nikolino%2C%20how%20can%20attached%20a%20sample%3F%20Thanks.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2633243%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20problem%20display%20conditional%20formating%20and%20time%20stamp%20on%20a%20shared%20excel%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2633243%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1125103%22%20target%3D%22_blank%22%3E%40MarisaL%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20attache%20a%20samble%20if%20you%20click%20first%3C%2FP%3E%3CDIV%20class%3D%22lia-quilt-column%20lia-quilt-column-08%20lia-quilt-column-left%22%3E%3CDIV%20class%3D%22lia-quilt-column-alley%20lia-quilt-column-alley-left%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Freplypage%2Fboard-id%2FExcelGeneral%2Fmessage-id%2F109904%22%20target%3D%22_blank%22%3EOpen%20full%20text%20editor%3C%2FA%3E%3C%2FDIV%3E%3CDIV%20class%3D%22lia-quilt-column-alley%20lia-quilt-column-alley-left%22%3Eand%20then%2C%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22lia-quilt-column%20lia-quilt-column-16%20lia-quilt-column-right%22%3E%3CDIV%20class%3D%22lia-quilt-column-alley%20lia-quilt-column-alley-right%22%3E%3CDIV%20class%3D%22lia-form-submit%20lia-button-group%22%3EDrag%20and%20drop%20here%20or%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Freplypage%2Fboard-id%2FExcelGeneral%2Fmessage-id%2F109904%23%22%20target%3D%22_blank%22%3Ebrowse%3C%2FA%3E%20files%20to%20attac.%3C%2FDIV%3E%3CDIV%20class%3D%22lia-form-submit%20lia-button-group%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22lia-form-submit%20lia-button-group%22%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EDespite%20my%20very%20limited%20knowledge%20in%20this%20area%2C%20I%20would%20like%20to%20send%20you%20some%20information%20that%20might%20help%20you%20further.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22lia-form-submit%20lia-button-group%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fexamples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EExamples%20of%20common%20formulas%20in%20lists%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Flist-and-library-column-types-and-options-0d8ddb7b-7dc7-414d-a283-ee9dca891df7%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EList%20and%20library%20column%20types%20and%20options%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fdeclarative-customization%2Fcolumn-formatting%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EUse%20column%20formatting%20to%20customize%20SharePoint%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThank%20you%20for%20your%20patience%20and%20understanding%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Eand%20hope%20that%20you%20will%20be%20offered%20a%20solution%20that%20fits%20your%20problem%20quickly.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EI%20also%20wish%20you%20a%20lot%20of%20fun%20with%20Microsoft%20products.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20cannot%20do%20great%20things%20-%20only%20small%20ones%2C%20but%20those%20with%20great%20love.%3C%2FP%3E%3CP%3EMother%20Teresa%C2%A9%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FDIV%3E%3CDIV%20class%3D%22lia-form-submit%20lia-button-group%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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. 

17 Replies

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)

Thank you Nikolino. I will do that right now.
The shared sheet is running on Window 10 Prof. plateform.
Microsoft Excel for Microsoft 365 MSO (16.0.14228.20216) 64-bit

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)

Hi Nikolino, how can attached a sample? Thanks.

@MarisaL 

You can attache a samble if you click first

Drag and drop here or browse files to attac.
 
Despite my very limited knowledge in this area, I would like to send you some information that might help you further.

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

 

@MarisaL 

The only thing that still comes to mind is that you can...

Track changes in a Shared Workbook

 

 

Hi Marisal. It could be this as I have found problems with functionality when sharing sheets. When you share a sheet with someone it will open up in a browser. There is a button that says Open with Desktop App which is near the center just below the ribbon (easy to overlook) If they press this and close the browser when prompted all funtionality and formatting returns. I hope this helps
I think this sheet is protected. Could you post an unprotected sheet ?

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.  

No it has nothing to do with being protected I was just curious about the time stamp for myself. No matter Please see my first post as I believe that may be the problem.
@Cambosity100 I already instruct my users to doing that, it was working when they first open up but then timestamp and highlight disappeared.

Here is the timestamp i have in mine, =IF(H3<>"",IF(I3<>"",I3,NOW()),"") for your reference.
Sorry I was no use. I am at a loss. Thankyou for the formula. Maybe someone like Sergei could help ? He is a very regular problem solver in the community. I hope you find the answer
Thank you for the suggestion, I will test it out soon.