Ask Experts Questions for FREE Help !
Ask
    imbashar's Avatar
    imbashar Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jun 10, 2011, 01:31 PM
    Excel Connection fuction
    There are two excel workbooks are connected by (=[Book1.xlsx]Sheet1!$A$1) but there are two user A and B, I just want when a enter something in cell it show in red font color & when B enter something in cell it shows in Blue font color. Please some one tell me how it will done?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jun 13, 2011, 12:59 AM

    This would require VBA as well as knowing what the username is on the computers the two users use when logging in their computers.

    Is VBA OK?
    Do you know the login usernames of the two users? What are they?
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel 2007 to have excel 2003 look? [ 6 Answers ]

Hey I have Microsoft Excel 2007, from my course at college I have been given instructions to do a task. However these instructions are for excel 2003. How do I change my excel 07 to look like excel 03 so that it is easier. I know there is a way, help greatly appreicated thanks.

Excel Sheets Connection! [ 3 Answers ]

Dear All, (Sorry my question is not about word processor) I want to ask that how can be the data added automaticall to from one excel sheet to another. For e.g I have one excel sheet by the name ex1.xls and 2nd is ex2.xls. Let suppose I want to add something in ex1.xls and want the same addition...

Connection of excel [ 1 Answers ]

How to connect one excel sheet to other excel sheet

Using fuction "Mode" within a Pivot Table? Or calculating the mode with conditional? [ 4 Answers ]

I want to know which number appears most frequently within a table by instructor code. For example, I want to produce a report that searches column A for an instructor code (for example, any instructor code "ba*") and then finds the mode of the corresponding cell in column B. I know I could...

View more questions Search