+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting Rules from multiple columns based on conditions!!!

  1. #1
    Registered User
    Join Date
    06-05-2014
    Posts
    2

    Conditional Formatting Rules from multiple columns based on conditions!!!

    Hi,

    I need help with conditional formatting.
    I searched many places and did not the one which I am looking for.

    X72nZ.png

    So, basically I have two columns. Column H (deals with severity (P1, P2, P3, P4)) and Column N (Number of days).

    My condition should be like this..

    If P1 then
    No of days (3 conditions)
    1. <10 (Green color)
    2. >=10 (Orange)
    3. >=20 (Red)
    If P2 or P3 or P4 then
    No of days (3 conditions)
    1. <25 (Green color)
    2. >=25 (Orange)
    3. >=50 (Red)

    I have filled it for one row (current selection) and I have to do it for all other columns (No of days, column).

    =IF(OR($H$6="P2", $H$6="P3", $H$6="P4"), $N$6>=50)

    =IF(OR($H$6="P2", $H$6="P3", $H$6="P4"), $N$6<25)

    =IF(OR($H$6="P2", $H$6="P3", $H$6="P4"), $N$6>=25)

    =IF($H$6="P1",$N$6>=20)

    =IF($H$6="P1",$N$6<10)

    =IF($H$6="P1",$N$6>=10)

    Please let me the best way to get out of this!!!

    Image [1]: http://i.stack.imgur.com/X72nZ.png

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

    Re: Conditional Formatting Rules from multiple columns based on conditions!!!

    To attach a Workbook
    (please do not post pictures of worksheets)
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"
    Post your workbooks directly to the forum.
    Ben Van Johnson

+ 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 rules over specific columns
    By hk4kim in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-20-2013, 10:49 AM
  2. conditional formatting rules for a cell on sheet 1 based on rules from sheet 2
    By jsard in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-15-2013, 09:22 AM
  3. [SOLVED] Conditional Formatting based on multiple conditions
    By Cyberbeing in forum Excel General
    Replies: 9
    Last Post: 05-16-2013, 02:34 AM
  4. Conditional formatting based on multiple rules
    By Pyrex238 in forum Excel General
    Replies: 7
    Last Post: 05-06-2011, 03:20 AM
  5. Conditional formatting based on multiple conditions
    By bjvick in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-03-2010, 07:05 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