Forum Discussion
Having problem display conditional formating and time stamp on a shared excel sheet.
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, ...
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 🙂