+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting two columns

  1. #1
    Registered User
    Join Date
    01-09-2014
    Location
    Cleveland, OH
    MS-Off Ver
    Excel 2007 or 10
    Posts
    1

    Cool Conditional Formatting two columns

    Hi,
    I am trying to based on what is in column M, format column H,J, and K.
    So, if M="FDA" then H,J, and K should be formatted with a particular shading and pattern style.
    The rule should apply to every row. I don't know if I should write a macro to apply to every row? Or I can use the conditional formatiing feature?
    Please advise,
    Thanks,

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Conditional Formatting two columns

    welcome to the forum, May. since they are non-contiguous ranges, you can try a few methods (say data ends at row 10):
    1(i) do 1 range first. select the range you want to apply to (say from H2:H10)
    (ii) OR, select 1 range, press & hold on to the CTRL key, select another & another. BUT, your last cell must be on the 1st row you want to highlight (i.e. row 2). so your last selection must be from bottom up. if it's too confusing, use (i)

    2. go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
    =M$2="FDA"

    3 (i) if you have used 1(i), you can repeat the steps for Column J & K OR in the window where you can see the header Conditional Formatting Rules Manager, go to the Applies to portion, click on the end of the range, press & hold on the CTRL key to select the other 2 ranges
    (ii) if you used 1(ii), you are done after clicking OK

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. conditional formatting three columns or more
    By awinchester in forum Excel General
    Replies: 7
    Last Post: 06-14-2016, 01:38 AM
  2. IF columns with Conditional Formatting
    By adfeddon in forum Excel General
    Replies: 3
    Last Post: 08-09-2013, 10:52 AM
  3. Conditional formatting two columns
    By Bupitz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-13-2013, 03:54 PM
  4. using conditional formatting for 2 different columns
    By AlexandraJ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2010, 05:04 PM
  5. conditional formatting for 3 columns (?)
    By eighcoop in forum Excel General
    Replies: 3
    Last Post: 01-06-2010, 08:02 PM

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