TommyKingSTA

Ah of course! Thanks pal, forgot all about that! haha.

I've recently spent quite a while trying to get the following formula to work and i finally have, but now i need to figure out how to not only change the text appearing in the cell but also the colour of that cell. The formula is as follows: =IF(COUNTIFS('Group Info'!C17:'Group Info'!F17,"<>"&"",'Group Info'!C17:'Group Info'!F17,"<>"&"Yes"),"Not Ready","Ready") ..This formula basically means that if all 4 cells on another worksheet ALL say 'Yes', then this cell will show 'Ready'. But, if any one of those cells doesnt say 'Yes' then to reply 'Not Ready'. Now, can anyone help me with not only changing the text but also changing the colour of the cell to red if 'Not Ready' or green if 'Ready'? Thanks.

When creating a Notebook on OneNote online and using the "Open in app" button the following error occurs and will not open the notebook. "We couldn't open that location. It might not exist or you might not have permission to open it." The NoteBook is saved on a shared OneDrive for business for colleagues to access too, but they are also having the same issue. The destination folder that is also listed on the error message is pointing to the correct place and the permissions are set to "Can edit" for everyone. Cannot figure this out so, any help appreciated. Thanks.