+ Reply to Thread
Results 1 to 6 of 6

conditional formatting based on another cell & leave blank cells

  1. #1
    Registered User
    Join Date
    09-17-2019
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    15

    conditional formatting based on another cell & leave blank cells

    Hoping you good people can help me (again!)

    I want to apply some conditional formatting to my excel sheet:

    -If level states ">75" - colour cells only containing hours Green
    -If level states "<20" - colour cells only containing hours Red

    Blank cells to not be any colour

    Can anyone help?
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-10-2017
    Location
    INDIA
    MS-Off Ver
    365
    Posts
    184

    Re: conditional formatting based on another cell & leave blank cells

    Check this out!

    *Need to have numbers in the cells to be able to use the formatting.
    Attached Files Attached Files
    *If you wish you click on *,a way to say ThankYou

  3. #3
    Forum Contributor shank_mis's Avatar
    Join Date
    09-08-2018
    Location
    Delhi
    MS-Off Ver
    2010
    Posts
    128

    Re: conditional formatting based on another cell & leave blank cells

    Select Cell D3 and follow following steps:
    Conditional Formatting>>New Rule>>Formula:

    For Green: =AND($C3=">75",D3>0) Select format color green
    For Red: =AND($C3="<20",D3>0) Select format color Red

    Click on Format Painter. Select Entire range D3:G7.
    Done.
    Shashank Mishra
    Please hit "Add Reputation" Button if you liked the answer.

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,243

    Re: conditional formatting based on another cell & leave blank cells

    1st formula would be
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    2nd would be
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: conditional formatting based on another cell & leave blank cells

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    09-17-2019
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    15

    Re: conditional formatting based on another cell & leave blank cells

    amazing - Thanks for the replies guys!

+ 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 for blank cell based on another cells date
    By trent88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2019, 12:50 PM
  2. [SOLVED] How to leave leave cell blank if all cells added together = 0
    By jmitch26 in forum Excel General
    Replies: 3
    Last Post: 07-30-2019, 11:00 PM
  3. Replies: 3
    Last Post: 02-09-2015, 09:00 AM
  4. [SOLVED] conditional formatting time and leave other blank
    By jekidi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-08-2013, 11:09 AM
  5. [SOLVED] Conditional formatting based on dates and blank cells
    By formatting freak in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-10-2013, 09:23 AM
  6. Conditional formatting blank cells based on another cell value
    By 6MPS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2013, 11:59 AM
  7. [SOLVED] 3 Outcomes Conditional Formatting based on 4 blank/non blank cells
    By Supraman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-14-2012, 06:21 AM

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