+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting Using Formula help needed across multiple cells in a column

  1. #1
    Forum Contributor
    Join Date
    10-11-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    230

    Conditional Formatting Using Formula help needed across multiple cells in a column

    Attached is a workbook that has cell V19 functioning as I want it to. There is Conditional Formatting on the cell that says if the sum in O19 - P19 is less than or equal to zero, and if the value in V19 is greater than 20000000, then turn the cell red and change the font to red. You can see that the conditional formatting is working for cell V19.

    I now need to get that same conditional formatting to work dynamically for all of the cells above it in rows 2-18.

    I also need to know how to get it to work if I insert any rows above the blue line in row 20. The conditional formatting is not dynamic even if I use Copy on row 19 and Insert Copied Cells above the blue line anywhere.

    Any help is appreciated. Thanks.Conditional Formatting help.xlsx

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Conditional Formatting Using Formula help needed across multiple cells in a column

    Change the absolute references in the CF rule to relative ones. Hence,

    =AND(SUM($O19:$P19)<=0,$V19>20000000)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Contributor
    Join Date
    10-11-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: Conditional Formatting Using Formula help needed across multiple cells in a column

    Ace_XL: The absolute reference should not have been in there in the file I sent. Apparently when I re-wrote the formula to try it again, I forgot to remove them. Having said that, it still does not become dynamic when that cell is copied into the ones above it. It changes on one or two of them but I need it to function on all of them. Any other thoughts?

+ 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: 13
    Last Post: 06-02-2014, 12:58 AM
  2. Replies: 5
    Last Post: 09-24-2012, 05:14 PM
  3. [SOLVED] Formula help required to enable conditional formatting of cells that meet multiple con
    By Barbara Excel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-14-2012, 10:10 AM
  4. [SOLVED] Conditional formatting help needed - 250+ cells with one CF formula?
    By Eelko-Jan in forum Excel General
    Replies: 9
    Last Post: 05-04-2012, 12:46 PM
  5. Replies: 3
    Last Post: 01-26-2010, 08:36 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