+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting Rules with Shading

  1. #1
    Registered User
    Join Date
    10-13-2012
    Location
    Nutley,NJ
    MS-Off Ver
    Excel 2011
    Posts
    77

    Conditional Formatting Rules with Shading

    I want to create a sheet that highlights progression so if a cell value(c2) is higher than the cell directly its left(b2) then C2 should be shaded green. If C2 is lower than B2 then C2 is shaded red. If C2 and B2 are equal, the n C2 isn't shaded. I got it working for cell C2 but I don't know what's wrong with my rules that it doesn't work for D2 E2 F2 and G2. I included the spreadsheet and would appreciate whatever help I can get.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Conditional Formatting Rules with Shading

    The range that your conditional formatting is applied to is off. See the attached sample workbook for solution.
    Attached Files Attached Files

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Conditional Formatting Rules with Shading

    Edit conditional formatting rules to remove double quotes from the formula used. It will work then.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Registered User
    Join Date
    10-13-2012
    Location
    Nutley,NJ
    MS-Off Ver
    Excel 2011
    Posts
    77

    Re: Conditional Formatting Rules with Shading

    thank you!

+ 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. Conditional formatting rules
    By puzzlelover22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2014, 12:45 PM
  2. conditional formatting rules for a cell on sheet 1 based on rules from sheet 2
    By jsard in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-15-2013, 09:22 AM
  3. [SOLVED] Conditional Formatting Rules Help
    By PCAg in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-11-2012, 05:33 PM
  4. Conditional Formatting with more than 3 rules
    By vickyho1008 in forum Excel General
    Replies: 5
    Last Post: 07-24-2008, 10:06 PM
  5. [SOLVED] conditional formatting-shading
    By Shooter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2005, 05:06 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