98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Remote Text Posting
Remote Text Posting
Resolved · Urgent Priority · Version 2007
Fri 1 May 2009, 12:56Delegate Francis said...
Francis has attended:
Excel Advanced course
Remote Text Posting
Hi,
I would like to have "BLOCKED" written in a 'Cell-G7' based on the formatting colour in 'Cell-G7' - however, I want to be write this formula from a cell other than 'Cell-G7'
FOR EXAMPLE:
I have formatted 'Cell-G7' so that it turns black based on a condition from another cell. Now I would like the word "BLOCKED" to appear in 'Cell-G7' the moment it turns black, without writing the formula in 'Cell-G7' itself.
Tue 5 May 2009, 10:20Trainer Amanda said...
RE: Remote Text Posting
Hello Francis
Thank you for your question.
I don't think this will be as straightforward as it might sound; and have the feeling that this would be something that would require you to write VBA code to resolve. I will check with some of my colleagues and let you know.
Kind regards
Amanda
Fri 5 Mar 2010, 15:36Trainer Simon said...
RE: Remote Text Posting
Dear Francis,
Sorry for the delay in responding.
Thanks for your forum post which after review we have agreed that there is a solution available but it is beyond the scope of this forum.
This sort of requirement falls under consultancy and we would need to review working examples of your files along with a list of key objectives you require.
We will then confirm the scope of work, duration and costs for you to decide on. If you would like to explore this option further please feel free to contact JacobATstl-training.co.uk.
Kind regards,
Simon
Thu 11 Mar 2010: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Date and timeCTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON |
