Results 1 to 6 of 6

Conditional Formatting Across Multiple Columns, But Only Some Columns Turn Color

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-01-2019
    Location
    Illinois
    MS-Off Ver
    2016
    Posts
    223

    Conditional Formatting Across Multiple Columns, But Only Some Columns Turn Color

    I've used conditional formatting many times and this is the first time it hasn't worked as I expected.

    I have three conditional colors that I want to apply across a row, from columns B to F, and I want to apply this coloring one row at a time to rows 15 to 145. I have a formula to determine which rows should, and should not, be colored.

    The good news is that color appears on every row that should have color, and does not appear on every row that should not have color.

    The bad news is that the color appears in only one column of each row that should be colored and not all of the columns from B to F. Two of the conditional coloring commands color only cells in column 'B' and one conditional coloring command colors only cells in column 'F'. However, to repeat, the proper color always appears in the proper row.

    I used =$B$15:$F$145 to designate the area to which the formulas for conditional coloring should be applied.

    Does anyone have an idea of what I've done wrong?

    This has always worked fine before, so I'm very puzzled.
    Attached Files Attached Files
    Last edited by lovecolorado; 03-13-2019 at 06:05 PM. Reason: Add a file, per the request in a response

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting: If Date is ____ Make subsequent rows turn color
    By morerockin in forum Excel General
    Replies: 1
    Last Post: 05-20-2015, 09:23 AM
  2. [SOLVED] Conditional Formatting - Multiple Columns
    By VegasL in forum Excel General
    Replies: 3
    Last Post: 08-29-2013, 01:03 PM
  3. Using color scale conditional formatting on columns
    By moty.98 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2013, 11:05 AM
  4. Replies: 2
    Last Post: 04-15-2013, 02:05 PM
  5. Conditional Formatting Between Multiple Columns
    By p_arab in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-14-2013, 03:47 PM
  6. Excel 2007 : Conditional Formatting for Multiple Columns
    By AlexisDis in forum Excel General
    Replies: 3
    Last Post: 10-18-2011, 12:00 PM
  7. Conditional formatting multiple columns
    By Moebius8 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2008, 10:55 AM

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