+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting Help - Entire Column, but each cell pointing to different cell

  1. #1
    Registered User
    Join Date
    04-17-2012
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2010
    Posts
    2

    Conditional Formatting Help - Entire Column, but each cell pointing to different cell

    I am trying to figure out how to format an entire column of cells (108 entries in total) so that each particular cell will become highlighted if data exists in a corresponding cell on another worksheet. I have figured out how to do it in on a cell by cell basis, but can't seem to figure out how to do all 108 cells at once. If I try to conditionally format them all, then the entire column becomes highlighted.

    Example:

    I want a cell to become highlighted if data is entered on in another cell on another worksheet.

    The current formula I am using on cell D2 on the main worksheet is:

    ='SoA & Disbursements'!$F$2>0

    Therefore, if a value exists in cell F2 on the corresponding worksheet, this cell becomes highlighted. This seems to work no problem. Can I expand this formula to encompass the 108 cells in column D (D2:D109) so that each cell points to a particular cell in column F (F2:F109), or do i have to manually enter this formula into all 108 cells?

    Thanks for any input.

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Conditional Formatting Help - Entire Column, but each cell pointing to different cell

    try it like this

    'SoA & Disbursements'!$F2>0
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

  3. #3
    Registered User
    Join Date
    04-17-2012
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Conditional Formatting Help - Entire Column, but each cell pointing to different cell

    Fantastic! That solved it. Thanks so much for the quick and easy fix!

  4. #4
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Conditional Formatting Help - Entire Column, but each cell pointing to different cell

    No problem, glad i could help, and good luck with the rest of the project.

+ 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