+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting - Highlight cell based on two criteria

  1. #1
    Registered User
    Join Date
    01-26-2015
    Location
    Michigan
    MS-Off Ver
    2007
    Posts
    2

    Conditional Formatting - Highlight cell based on two criteria

    Hello,

    Looking for a little help here as I can only figure out how to make half of this work.

    Here is the scenario:
    Step 1: Highlight cell A2 if cell A1 > 0. This part was simple and I was able to accomplish with conditional formatting.

    Here is the part I am struggling with:
    Step 2: Remove highlight from A2 when a number is entered into A2.

    Any ideas?

    Thank you,

    Eric

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Conditional Formatting - Highlight cell based on two criteria

    Hi,

    Maybe

    =AND(A1>0,A2="")
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    01-26-2015
    Location
    Michigan
    MS-Off Ver
    2007
    Posts
    2

    Re: Conditional Formatting - Highlight cell based on two criteria

    That worked! Thank you!

    I'm embarrassed it was something so easy. I was making it way too complicated. As usual....simple is better.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Conditional Formatting - Highlight cell based on two criteria

    Indeed so.

    Been there and got so many T shirts I could open a market stall.

    Glad it helped

+ 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] A conditional formatting rule that will highlight a cell based on certain criteria/date
    By FEL2014 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-24-2014, 03:51 PM
  2. Replies: 7
    Last Post: 06-10-2013, 09:39 AM
  3. [SOLVED] Using conditional formatting to highlight an entire row based on one cell
    By eizanendoso in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-31-2012, 09:59 AM
  4. Replies: 5
    Last Post: 04-22-2011, 02:50 PM
  5. Replies: 6
    Last Post: 05-16-2008, 06:28 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