+ Reply to Thread
Results 1 to 8 of 8

Formating cells with 2 conditions

  1. #1
    Forum Contributor
    Join Date
    12-17-2019
    Location
    Portugal
    MS-Off Ver
    office 2019
    Posts
    167

    Formating cells with 2 conditions

    hi everyone,

    I would like formating (Fill) cells with 2 conditions (the second condition is more important than the first, if is tue for both i want the cell in "Dark blue")
    My english is so bad that I make a sheet to explain what I would like.

    Many Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Formating cells with 2 conditions

    Please try
    =E4<3 for light blue

    =(E4<3)*(H4>0) for dark blue
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    12-17-2019
    Location
    Portugal
    MS-Off Ver
    office 2019
    Posts
    167

    Re: Formating cells with 2 conditions

    thanks for your help !
    Is almost ok... the formating in "I4" is in dark blue because is true for both conditions, but if you take off the character in "H4" the cell "I4" must come light blue and is not. (???)

  4. #4
    Forum Contributor
    Join Date
    12-17-2019
    Location
    Portugal
    MS-Off Ver
    office 2019
    Posts
    167

    Re: Formating cells with 2 conditions

    Quote Originally Posted by Bo_Ry View Post
    Please try
    =E4<3 for light blue

    =(E4<3)*(H4>0) for dark blue
    thanks for your help !
    Is almost ok... the formating in "I4" is in dark blue because is true for both conditions, but if you take off the character in "H4" the cell "I4" must come light blue and is not. (???)

  5. #5
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Formating cells with 2 conditions

    I just delete H4
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    12-17-2019
    Location
    Portugal
    MS-Off Ver
    office 2019
    Posts
    167

    Re: Formating cells with 2 conditions

    Sorry to bored you again ! But i'm completed confused !! I understand what you done but then when I try to make the same to another cells i can't. Can you please see if is easy for you the 4 questions in the new sheet ??
    Thanks
    Attached Files Attached Files

  7. #7
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Formating cells with 2 conditions

    Same formula
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    12-17-2019
    Location
    Portugal
    MS-Off Ver
    office 2019
    Posts
    167

    Re: Formating cells with 2 conditions

    many thanks !!!

+ 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. Conditional Formating two conditions
    By tims31 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-04-2014, 08:02 AM
  2. Formating a cell on three conditions
    By moosefist in forum Excel General
    Replies: 4
    Last Post: 12-14-2010, 02:08 PM
  3. Conditional Formating with 4 Conditions
    By Justinmih in forum Excel General
    Replies: 1
    Last Post: 11-23-2010, 08:25 PM
  4. Can I use more than three conditions for conditional formating?
    By Jmaas in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-28-2006, 07:20 PM
  5. Excel: only THREE conditions for conditional formating of cells???
    By Mat from Nancy, France in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-20-2005, 11:05 PM
  6. More that 3 conditions for conditional formating?
    By Jerry Kinder in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-19-2005, 02:05 PM
  7. Cumulating formating conditions
    By Dragos in forum Excel General
    Replies: 2
    Last Post: 09-03-2005, 06: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