+ Reply to Thread
Results 1 to 2 of 2

Override Conditional Formatting

  1. #1
    Registered User
    Join Date
    09-13-2011
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2007
    Posts
    4

    Override Conditional Formatting

    I am trying to add some conditional formatting to the spreadsheet in the picture attached.
    I would like for the ROW to be filled in different colours based upon the combination of blank active cells within said row.

    If as in my picture F2,G2,H2&I2 are NotBlank then I would like for the row to be filled Blue
    If F2,G2&H2 are not Blank, but I2 is then I would like for the row to be filled Green
    If F2&G2 are NotBlank, but H2 & I2 are then I would like the row to be Yellow
    If F2 is NotBlank but G,H&I2 are then I would like the row to be Orange
    If F2:I2 are all blank then I would like for the the row to stay white.

    Is this possible?EXCEL TEST.png

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    6,804

    Re: Override Conditional Formatting

    you should be able to use a formula like

    AND( $F2<>"",$G2 <> "", $H2 <> "", $I2 = "")
    in conditional formatting and assign a colour

    And add rules for each colour

    if you attach a spreadsheet rather than an image that would help
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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] I need to override a color fill set by Conditional Formatting
    By Gene@action in forum Excel General
    Replies: 8
    Last Post: 12-06-2019, 11:15 AM
  2. Override conditional formatting issue
    By jpruffle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-23-2011, 08:36 PM
  3. Override conditional formatting
    By greekboyuk in forum Excel General
    Replies: 12
    Last Post: 03-02-2011, 05:40 PM
  4. How can you override cell shading using Conditional formatting?
    By mrgillus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-10-2009, 11:46 AM
  5. [SOLVED] Prevent conditional formatting from being override
    By crapit in forum Excel General
    Replies: 1
    Last Post: 11-06-2005, 07:00 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