+ Reply to Thread
Results 1 to 4 of 4

Conditional formatting based on the 1st column

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    London
    MS-Off Ver
    Excel 2003 Excel 2010
    Posts
    189

    Conditional formatting based on the 1st column

    Dear all, I'm not sure if it is possible to implement the following conditional formatting using some formula-based.

    There are 10 columns: column A1:J100, and each row represents a case. If column A is not blank, then all columns A - J will have a bold font. For example, if cell A5 is not blank, then the row A5:J5 will have a bold font. When doing the conditional formatting based on formula, I can simply fix column A (e.g. =IF($A1<>"",1) for the whole area.

    But there is a problem: if I fix column A, then when I copy columns A:J to the next 10 columns (K:T), then the conditional formatting is still related to column A, which is not right.

    So my question is: how to work out the formula for conditional formatting so that the 10 columns is always formatted based on the first column, even the 10 columns are copied across? For example, columns A:J are based on the first column A, columns K:T are based on the first column K, and so on.

    Thanks in advance

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2301, rarely Office 2007
    Posts
    12,887

    Re: Conditional formatting based on the 1st column

    Copied across / filled across in the conventional way? I couldn't find a way. However if I select A1:J10 and while holding down Ctrl click and drag a copy of that range over to K1:T10 the formatting follows and FM creates a copy of that rule using the new range. The two rules are unaffected by each other.

    Is this close enough?
    Last edited by FlameRetired; 03-08-2015 at 06:11 PM. Reason: bad interpret

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    London
    MS-Off Ver
    Excel 2003 Excel 2010
    Posts
    189

    Re: Conditional formatting based on the 1st column

    Hi FR, do you mean that it is not possible to implement?

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2301, rarely Office 2007
    Posts
    12,887

    Re: Conditional formatting based on the 1st column

    Quote Originally Posted by alice2011 View Post
    Hi FR, do you mean that it is not possible to implement?
    I'm not quite sure I know what you mean by that. I've edited my post a bazillion times. Our posts may have crossed in the "mail". Did you read about the click and drag?

+ 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. Replies: 0
    Last Post: 11-20-2013, 11:28 AM
  2. Macro for Conditional formatting of a column based on another column
    By surya5489 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-11-2013, 06:24 AM
  3. Replies: 5
    Last Post: 09-24-2012, 05:14 PM
  4. Replies: 2
    Last Post: 06-02-2010, 02:34 PM
  5. [SOLVED] conditional formatting based on column
    By snax500 in forum Excel General
    Replies: 4
    Last Post: 04-27-2005, 02:06 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