+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting based on a cell entry type...

  1. #1
    Forum Contributor
    Join Date
    03-24-2010
    Location
    North West UK
    MS-Off Ver
    2013
    Posts
    112

    Conditional formatting based on a cell entry type...

    Hi,

    I'm trying to find a way to (if I highlight a column) I can use conditional formatting to say only to format those cells in that column that have a number entry but to ignore cells that have words or blanks.

    I want to then say if the cells with figures are above or below the adjacent cell to the right of it then change colour if the value of the cell is either above or below that adjacent cell. (Office 365 version)

    Any ideas?

    Lew

  2. #2
    Registered User
    Join Date
    07-26-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Conditional formatting based on a cell entry type...

    Hi,

    Assuming the data is on columns A & B,

    Keep the cursor in cell A1 and enter the below formula in conditional formatting
    '=AND(($A1*1)>0,A1<B1) >>>> this is to format cells if value is less than the adjcent cell in B

    select some color to highlight

    then add the next condition

    '=AND(($A1*1)>0,A1>B1) >>>> this is to format cells if value is more than the adjcent cell in B

    select another color to highlight.

    Thanks

+ 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 a cell based on an entry into another cell
    By brettolma in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-25-2012, 04:19 PM
  2. Replies: 4
    Last Post: 09-27-2011, 04:16 AM
  3. Changing font type based on conditional formatting
    By LegendaryPunk in forum Excel General
    Replies: 1
    Last Post: 01-20-2010, 02:48 PM
  4. Replies: 15
    Last Post: 07-23-2008, 06:59 AM
  5. [SOLVED] Conditional formatting of an entire row based on a cell text entry
    By Gilles Desjardins in forum Excel General
    Replies: 2
    Last Post: 12-22-2005, 07:55 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