+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting using a cell in another worksheet

  1. #1
    Registered User
    Join Date
    07-08-2008
    Location
    Michigan
    Posts
    11

    Conditional Formatting using a cell in another worksheet

    I'm trying to use conditional formatting for a cell where the cell will turn green if the value of the cell =

    =VLOOKUP(B5,'[Corp Ovhd 6.08_Final.xls]summary'!$F$4:$I$150,4,FALSE)
    and the cell will turn red if the value of the cell is not equal to the formula above.

    Unfortunately, I don't think you can use conditional formatting when linking to a cell in another file.

    Does anyone have any ideas for a way around this?

    Thanks,

    Mike

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,576
    You could put your formula into a cell (or column of cells) and then either format them with white font or hide the column. Then you can reference that cell(s) in your conditional formatting. Would that work?

    ChemistB

  3. #3
    Registered User
    Join Date
    07-08-2008
    Location
    Michigan
    Posts
    11
    Yeah the white font would work perfectly for what I need.


    Thanks for the help,

    Mike

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1