+ Reply to Thread
Results 1 to 4 of 4

conditional formatting adjacent cell

  1. #1
    Registered User
    Join Date
    04-18-2013
    Location
    United Kingdom
    MS-Off Ver
    Office 365
    Posts
    90

    conditional formatting adjacent cell

    Hi, in column B I have the numbers 1 to 40, I want to conditional format column B based on the Values of column C being less than 4 but keeping the numbers 1 to 40 in column B.

    Thanks.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: conditional formatting adjacent cell

    Assuming that your data start in b2(headers in row1), then highlight your range in column b and in CF rules use this formula.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    How can you use Conditional Formating.

    --In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Contributor jayajaya_4's Avatar
    Join Date
    05-09-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    259

    Re: conditional formatting adjacent cell

    Hello

    try this

    =AND($C1<4,$B1>0)

    using CF

    Regards
    Jaya

  4. #4
    Registered User
    Join Date
    04-18-2013
    Location
    United Kingdom
    MS-Off Ver
    Office 365
    Posts
    90

    Re: conditional formatting adjacent cell

    Thank you Fotis1991 & jayajaya_4 for your reply, I have used jayajaya_4 suggestion and it works great, thank you both.

    Regards,

    Warston.

+ 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 in adjacent cell
    By kenjmaraty in forum Excel General
    Replies: 2
    Last Post: 04-25-2015, 11:55 AM
  2. Conditional formatting adjacent cell
    By dkbell@gmail.com in forum Excel General
    Replies: 1
    Last Post: 04-07-2015, 12:46 PM
  3. [SOLVED] adjacent cell conditional formatting
    By IronCladRooster in forum Excel General
    Replies: 3
    Last Post: 08-07-2014, 10:08 AM
  4. Conditional formatting on adjacent cell
    By branred in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-05-2013, 03:40 AM
  5. Conditional Formatting based on Adjacent Cell
    By MacroPolo in forum Excel General
    Replies: 3
    Last Post: 06-23-2012, 01:41 AM
  6. Conditional Formatting Based on Adjacent Cell
    By Yourgurlwantsme in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2010, 05:31 PM
  7. Replies: 2
    Last Post: 01-10-2005, 06: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