+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting can't apply to all cells properly

  1. #1
    Registered User
    Join Date
    11-11-2015
    Location
    Cabramatta West
    MS-Off Ver
    Excel 2013
    Posts
    8

    Conditional formatting can't apply to all cells properly

    Hello,

    I have two columns. If the right column is greater than the left column, i want it to show green, and if it's less, i want it to show red. Is there a way to drag this conditional formatting formula down so it applies to all rows without having to do the conditional formatting for each row one by one? I hope this makes sense.

    Attached is sample data:
    Book1.xlsx

    Any help is greatly appreciated! Cheers!

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,145

    Re: Conditional formatting can't apply to all cells properly

    Change to range of "Applies to" to your required range

    =A1>B1 red Applies to $A$1:$A$100

    =B1>A1 green Applies to $B$1:$B$100

+ 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. Apply set of conditional formatting to cells next to source cells
    By Feicstur in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-15-2015, 09:36 PM
  2. Apply conditional formatting to cells that meet certain criteria
    By dloper in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-19-2014, 09:00 PM
  3. Replies: 1
    Last Post: 06-12-2013, 12:23 PM
  4. [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
  5. [SOLVED] Conditional Formatting Apply to multiple Cells
    By ganesh81289 in forum Excel General
    Replies: 4
    Last Post: 06-22-2012, 11:08 PM
  6. Replies: 6
    Last Post: 01-09-2012, 02:29 AM
  7. Replies: 4
    Last Post: 10-17-2011, 11:01 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