Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Conditional formatting problem?

  1. #1
    New Member
    Join Date
    Dec 2012
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional formatting problem?

    I am have two worksheets in my excel document and I am trying to create a conditional formula between the two worksheets. Worksheet one is called New Monthly Expenses and worksheet 2 is called Income. I have one cell in each worksheet that needs to always match and I wanted to create a conditional formula to change colors when they don't match. I have no problems when I do this within the same page, but I can't seem to make this work when doing it between two different worksheets. I am trying to make (cell E474 in worksheet called New Monthly Expenses) to equal (cell n59 in worksheet called Income) and if they don't equal, I want them to change colors.
    I have been trying formulas like this.... ='NEW MONTHLY EXPENSES'!$E$474<>'$ INCOME $'! (and then from here it won't let me select the cell in the other worksheet).

    Any suggestions?

    Thanks

  2. #2
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Conditional formatting problem?

    HTH, Peter
    Please test any code on a copy of your workbook.

  3. #3
    New Member
    Join Date
    Dec 2012
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting problem?

    Also I forgot to mention that I am using Excel 2003.
    Thanks for any help

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •