+ Reply to Thread
Results 1 to 3 of 3

Formula or Conditional formatting for cell shading

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

    Formula or Conditional formatting for cell shading

    I want excel to shade a cell as long as its value meets two conditions

    SO for instance, if the person's age(B1) is 24, the person's gender(B2) is Male(1), And we enter Value 24 into cell B14 then the cell should be yellow
    BUT
    If the persons age(b1) is 24, the person's gender(b2) is Femail(2) and we enter the value 24 into cell B14 then the cell should be light green


    How can this be done? I've attached the example sheet.


    TestSheet.xlsx

  2. #2
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: Formula or Conditional formatting for cell shading

    Hi,

    Check the attached file and hope this is what you want.

    TestSheet.xlsx


    Regards,
    Paresh J
    Click on "* Add Reputation" as a way to say thanks

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

    Re: Formula or Conditional formatting for cell 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 on the Basis of Cell Shading
    By bykareem in forum Excel General
    Replies: 1
    Last Post: 12-03-2013, 02:43 AM
  2. [SOLVED] Conditional Formatting Shading Rows Based On A Single Cell
    By Kanook22 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-17-2012, 12:09 PM
  3. How can you override cell shading using Conditional formatting?
    By mrgillus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-10-2009, 11:46 AM
  4. [SOLVED] Conditional Cell Shading (based on the shading of other cells)
    By Tubby in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2006, 05:10 PM
  5. how do I use conditional formatting for alternating cell shading?
    By Exceluser in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-12-2006, 12:30 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