+ Reply to Thread
Results 1 to 9 of 9

Apply conditional formatting to multiple cells

  1. #1
    Registered User
    Join Date
    05-10-2022
    Location
    Norway
    MS-Off Ver
    365
    Posts
    13

    Apply conditional formatting to multiple cells

    I'm looking for a fast solution to apply conditional formatting to multiple cells

    For example if A1=1 fill row 1 green, now i want to apply that to A2,A3,... only that checking for values at A2 and so on. Is it a fast way to do this except from copying the formula and change the data
    Last edited by MKnoph; 10-06-2022 at 09:07 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,665

    Re: Apply conditional formatting to multiple cells

    So your CF rule, applied to A1, is this:

    =A1=1

    Now add the range to the Applies To box: =$A$1:$A$100 (or whatever the range is).

    Excel will take care of the rest.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    05-10-2022
    Location
    Norway
    MS-Off Ver
    365
    Posts
    13

    Re: Apply conditional formatting to multiple cells

    I think you missed the point, the problem is not how to apply conditional formatting for one line (that's easy) - the problem is how you can apply the same conditions over the next rows

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,665

    Re: Apply conditional formatting to multiple cells

    No, I did not miss the point at all. I use CF all the time.

    The Applies To box allows you to set a range. Excel will then interpret the rule for each row in the range. Try it.

    Better still: look at the attached, and then tell me I've missed the point.
    Attached Files Attached Files
    Last edited by AliGW; 10-06-2022 at 08:35 AM. Reason: Added example workbook.

  5. #5
    Registered User
    Join Date
    05-10-2022
    Location
    Norway
    MS-Off Ver
    365
    Posts
    13

    Re: Apply conditional formatting to multiple cells

    I got what you were thinking but still misunderstood (that could be on me as well as i could be a little unclear )

    What i want is for row 1 is to fill green if a1 is green, then for row 2 fill to green if A2 is green, then for row 3 if a3 fullfills the conditions.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,665

    Re: Apply conditional formatting to multiple cells

    Yes, that is EXACTLY what it does. All you need to do is fill in the range in the rule for cell A1.

    This is done with ONE rule set for A1 and the Applies To box filled in as I advised:

    AliGW on MS365 Beta Channel (Windows 11) 64 bit

    A
    1
    1
    2
    2
    3
    2
    4
    2
    5
    1
    6
    1
    7
    1
    8
    2
    Sheet: Sheet1

    Only one of us is misunderstanding, and I don't think it's me. How about providing a workbook mocked up with what you are trying to describe?
    Last edited by AliGW; 10-06-2022 at 08:55 AM.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,665

    Re: Apply conditional formatting to multiple cells

    If you want rows, then the rule is this:

    =$A1=1

    and the Applies To box is this: =$A$1:$D$100

    AliGW on MS365 Beta Channel (Windows 11) 64 bit

    A
    B
    C
    D
    1
    1
    x y z
    2
    2
    x y z
    3
    2
    x y z
    4
    2
    x y z
    5
    1
    x y z
    6
    1
    x y z
    7
    1
    x y z
    8
    2
    x y z
    Sheet: Sheet1
    Attached Files Attached Files
    Last edited by AliGW; 10-06-2022 at 09:00 AM. Reason: Added example workbook.

  8. #8
    Registered User
    Join Date
    05-10-2022
    Location
    Norway
    MS-Off Ver
    365
    Posts
    13

    Re: Apply conditional formatting to multiple cells

    Misunderstandment, i got now - thanks. The locked cells (dollar sign) made the difference.

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,665

    Re: Apply conditional formatting to multiple cells

    Thre you go - would have been SO much easier if you'd provided a sample workbook with a mock-up instead of trying to describe it.

+ 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: 2
    Last Post: 06-12-2022, 12:28 PM
  2. [SOLVED] the conditional formatting does not apply to all cells
    By alipezu in forum Excel General
    Replies: 1
    Last Post: 11-13-2016, 04:25 AM
  3. Replies: 1
    Last Post: 10-04-2016, 05:17 AM
  4. [SOLVED] Need to apply conditional formatting of a cell base on text in multiple other cells
    By Herkfixer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-19-2013, 08:59 PM
  5. [SOLVED] Conditional Formatting to apply to two cells
    By c.drysdale89 in forum Excel General
    Replies: 2
    Last Post: 01-25-2013, 08:26 AM
  6. [SOLVED] Conditional Formatting Apply to multiple Cells
    By ganesh81289 in forum Excel General
    Replies: 4
    Last Post: 06-22-2012, 11:08 PM
  7. Replies: 4
    Last Post: 10-17-2011, 11:01 AM

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