+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting using formula needed for the following problem

  1. #1
    Registered User
    Join Date
    05-10-2010
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    34

    Question Conditional Formatting using formula needed for the following problem

    Hello,
    I have a sheet same as the attached excel file; I need to apply conditional formatting to it.
    Can u please tell me the steps in excel how to apply conditional formatting for this data using a formula.


    My Problem is:
    In the excel sheet,

    If Column A is not equal to “ENTRY “then values in the following columns should be displayed in WHITE .The columns are:
    1. User id
    2. Approver id
    3. Period
    4. Date that user input entry
    5. Effective date of entry

    I.e. column A with values “GRRLINES” and “lines”, the values in the above columns mentioned should b in WHITE


    If column A is equal to “ENTRY” then those values should be in BLACK in the same above columns mentioned

    Note:
    1. Here we can give a range in top range corner of the excel sheet
    2. We can apply the formula

    Can u please help me with the steps to apply the formula as soon as possible. Please help me in this problem
    Attached Files Attached Files
    Last edited by Deepthik; 05-29-2010 at 10:05 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,843

    Re: Conditional Formatting using formula needed for the following problem

    Select the entire Column (L:O) use this formula:
    Please Login or Register  to view this content.
    Where:
    *Row>1 skips the header row in all cases
    *$A1>"" skips any row if the cell in column A is blank
    $A1<>"Entry" formats the cells in the row if the column A cell is not "Entry"
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    05-10-2010
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Conditional Formatting using formula needed for the following problem

    thank you so much for your help

  4. #4
    Registered User
    Join Date
    05-10-2010
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Conditional Formatting using formula needed for the following problem

    Quote Originally Posted by protonLeah View Post
    Select the entire Column (L:O) use this formula:
    Please Login or Register  to view this content.
    Where:
    *Row>1 skips the header row in all cases
    *$A1>"" skips any row if the cell in column A is blank
    $A1<>"Entry" formats the cells in the row if the column A cell is not "Entry"
    thank you so much for your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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