+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting Question

  1. #1
    Registered User
    Join Date
    11-29-2023
    Location
    USA
    MS-Off Ver
    Excel
    Posts
    10

    Lightbulb Conditional Formatting Question

    I am seeking each cell to the right to highlight (red if increase, green if decrease, yellow if same). I.e. D8 is less than D7, so it would be green. How would I apply this to all rows?

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,710

    Re: Conditional Formatting Question

    Please Login or Register  to view this content.
    Try these conditional format formula
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    11-29-2023
    Location
    USA
    MS-Off Ver
    Excel
    Posts
    10
    Quote Originally Posted by popipipo View Post
    Please Login or Register  to view this content.
    Try these conditional format formula

    How would I apply this to the entire sheet? I don't want all of them to compare their value to D7, yet, the cell to their left for each cell moving right.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2504
    Posts
    19,244

    Re: Conditional Formatting Question

    In post #1 it states "I am seeking each cell to the right to highlight" however D8 is below D7, not to the right.
    Assuming that the desired outcome is to highlight cells to the right the rules could be:
    =D7<E7 red
    =D7>E7 green
    =E7=E7 yellow
    Note that the rules are applied to E7:Z26 because there are no values to the left of column D.
    Note that rows 7:26 have only these three rules applied.
    Note that rows 28:47 are populated using: =D7>E7 only to illustrate how the relative reference formula will change as it is applied to different rows and different columns.
    Let us know if you have any questions.
    Attached Files Attached Files
    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 Question
    By Tubtech in forum Excel General
    Replies: 7
    Last Post: 05-20-2021, 08:19 AM
  2. [SOLVED] Conditional Formatting question
    By CHUMPHR in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-14-2019, 09:13 AM
  3. [SOLVED] Conditional Formatting Question?
    By Dan Gilles in forum Excel General
    Replies: 3
    Last Post: 08-14-2014, 12:22 AM
  4. [SOLVED] Conditional Formatting Question
    By cadustin in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-19-2013, 02:12 PM
  5. Conditional Formatting Question
    By nboris827 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-24-2012, 07:42 PM
  6. Conditional Formatting Question
    By Bryce.Carter in forum Excel General
    Replies: 1
    Last Post: 10-18-2010, 03:05 PM
  7. Conditional Formatting Question
    By sasquatchbill in forum Excel General
    Replies: 5
    Last Post: 08-04-2006, 11:24 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