+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting Cells based on row type

  1. #1
    Registered User
    Join Date
    06-23-2020
    Location
    Munich, germany
    MS-Off Ver
    365
    Posts
    2

    Red face Conditional Formatting Cells based on row type

    Hey Excel Community,

    I have a blank table

    Capture.JPG

    And want to make it look like this:

    Capture2.JPG


    Explanation:
    Every cell that is empty is colored red except when the column Type is Ground, then it should be greyed out whenever it is empty.

    I tried doing this by making a macro which was easy (dax filter and then color) but via conditional formatting (which is my goal here), I dont find a solution.



    Is there a way I can use a formula like

    IF(AND(ISEMPTY(Currentcell), ColumnB="Ground"), then:GREY, (else:) IF(ISEMPTY(Currentcell), then:RED)

    In the conditional formatting formula?



    Thanks for your help,

    hope my question is clear.


    Cheers,

    Janik

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    30,770

    Re: Conditional Formatting Cells based on row type

    You can't have IF/ELSE. You need two separate conditions, one for Blank and "Ground" and a second for Blank and not "Ground"

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

    and
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    06-23-2020
    Location
    Munich, germany
    MS-Off Ver
    365
    Posts
    2

    Re: Conditional Formatting Cells based on row type

    Hi TMS,

    Thanks for your answer.

    I understood, thank you for your help!

    I used:

    =AND(C2="", $B2="Ground")

    =AND(C2="", $B2<>"Ground")
    Last edited by JanikSchaefer; 06-23-2020 at 09:28 AM.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    30,770

    Re: Conditional Formatting Cells based on row type

    I used:

    =AND(C2="", $B2="Ground")

    =AND(C2="", $B2<>"Ground")
    Of course, my mistake ... I knew column B had to be fixed



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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. Replies: 1
    Last Post: 10-04-2016, 05:17 AM
  2. Replies: 1
    Last Post: 08-19-2016, 03:57 PM
  3. conditional formatting based on type of text
    By asmi in forum Excel General
    Replies: 2
    Last Post: 06-10-2016, 10:48 AM
  4. Conditional formatting based on a cell entry type...
    By Finalfrontier1976 in forum Excel General
    Replies: 1
    Last Post: 10-31-2014, 03:47 AM
  5. [SOLVED] Macro to create new tabs based off of a type and apply conditional formatting
    By quintans1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-03-2014, 10:56 AM
  6. Replies: 3
    Last Post: 08-04-2012, 07:22 PM
  7. Changing font type based on conditional formatting
    By LegendaryPunk in forum Excel General
    Replies: 1
    Last Post: 01-20-2010, 02:48 PM

Tags for this Thread

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