+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting based on below row

  1. #1
    Forum Contributor
    Join Date
    02-04-2015
    Location
    India
    MS-Off Ver
    365 (2202)
    Posts
    226

    Conditional formatting based on below row

    Hello,

    I'm looking to apply a conditional formatting based on below row.

    Everyday a add a new row to update previous dates value.

    See attached for e.g.

    Today I added a new row at row no. 5 to update cost of yesterday's date i.e. for 5th May 2021.

    Now I want to check if cost of row 5 is less or greater than row no. 6.

    Cost of cell B5 and C5 is greater then B6 and C6, so B5 and C5 cell color should get updated with green color.

    And the cost of D5 is less then D6, so it should get updated with red color.

    And tomorrow when I add a new row to update cost for 6th May, we should check the cost with 5th May cost.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,425

    Re: Conditional formatting based on below row

    This isn't automatic however perhaps it will help.
    Select cells B5:D9 and use the following formulas as conditional formatting rules.
    For Green: =B5>B6
    For Red: =B5<B6
    When a new row is inserted select cell B6 and the format painter and then press the left button of the mouse and pass the cursor across cells B5:D5
    Optionally you could edit the applies to of the two existing rules from =$B$6:$D$10 to =$B$5:$D$10
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Conditional Formatting based on another cells Conditional Formatting
    By chriskay in forum Excel General
    Replies: 4
    Last Post: 08-22-2019, 05:33 AM
  2. Replies: 1
    Last Post: 10-04-2016, 05:17 AM
  3. Replies: 1
    Last Post: 08-19-2016, 03:57 PM
  4. Macro to set up conditional message based on results of conditional formatting
    By paysola in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-04-2016, 12:38 AM
  5. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  6. Conditional Formatting via VBA: Change formatting in range based on value of each cell
    By ralphjmedia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2013, 10:37 AM
  7. Replies: 4
    Last Post: 01-06-2012, 05:07 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