+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting Based on Specific Word in Different column in Same Row

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    Dallas, Tx
    MS-Off Ver
    Excel 2003
    Posts
    2

    Conditional Formatting Based on Specific Word in Different column in Same Row

    How can I conditionally format (highlight) some cells in column K based on the values in column C of the same row?

    For Instance:

    I export a large report into excel from a worktool at work. I have many columns but I want to draw attention to cells in column K based on the text "###" on the same row in column C. (there are many different codes that populate besides ###)

    The only thing I can think of is to highlight an individual cell in column K and go to 'Use a formula to determine which cells to format" My formula is: =$C$1="###" and format the highlighting color.

    This report has over 500 rows so it is not feasible to do that same process 500 times and create 500 rules.
    Last edited by CoryBrock; 08-16-2012 at 11:22 PM.

  2. #2
    Registered User
    Join Date
    08-16-2012
    Location
    Dallas, Tx
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Conditional Formatting Based on Specific Word in Different column in Same Row

    Here is a screen shot. I have to manually highlight the cells green. I didnt highlight them all in this example. I would love for these cells to automatically highlight. I attached a screenshot. Unfortunately I cant attach the worksheet because it would be in violation of corporate policy. Any help would be much appreciated!!
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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