+ Reply to Thread
Results 1 to 3 of 3

Excel Conditional Formatting, quick Check formula does not work!

  1. #1
    Registered User
    Join Date
    12-10-2014
    Location
    Switzerland
    MS-Off Ver
    2010
    Posts
    1

    Excel Conditional Formatting, quick Check formula does not work!

    Hi,

    I have following problem and it is driving me nuts.

    I did so much research however I could not find the right formula yet how to adapt on the problem in order to fix it.

    What I like to do, based on the below chart, to use a conditional formatting check, which is allowing me to format all values directly, instead of doing it Cell by Cell.
    The cells need to be highlighted either in RED if the price is lower the the "OWN" price month per month. The price of the OWN product is changing every month.


    Anybody any clue how I can do that?

    Best

    Marijan
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-07-2011
    Location
    India, Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    212

    Re: Excel Conditional Formatting, quick Check formula does not work!

    Select cell C4 TO C4 and put below formula in condition formatting tab and format as you wish
    =OR(B4>C4,B4<>C4)

    Regards,
    Suhas

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Excel Conditional Formatting, quick Check formula does not work!

    Hi,

    It was a while before I found the simplest way - at least for me.

    Select one cell and apply the appropriate CF using the Formula option. Take care with the absolute references. If you're using another cell on the same row as part of an If condition then make that cell an Absolute column ref, but a Relative Row ref.

    Now when you start to exit the CF wizard when you come to the Apply To section select the whole of the range in which you want the CF.

+ 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. [SOLVED] Conditional Formatting with formula to check if the row is correct
    By rikkyshh in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-31-2013, 09:58 AM
  2. Replies: 1
    Last Post: 07-19-2012, 05:37 AM
  3. Replies: 3
    Last Post: 05-05-2010, 04:25 AM
  4. Conditional Formatting Formula Will not work
    By jdunkel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2007, 09:24 AM
  5. Replies: 4
    Last Post: 07-05-2005, 11:05 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