+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting for blank cells with dependency on other cell

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    748

    Conditional Formatting for blank cells with dependency on other cell

    Hi all,

    I have put in a random formula in cell A2 down to A13 for example purposes

    My query is hopw can I setup a CF in column b2 onwards to say: if cell a2 has a value, (ignore formula) and b2 is blank, highlight b2 in red. I want to apply the formula to the whole column (A) but if a100 has no value, I don't want b100 to highlight in red...

    thank you
    Attached Files Attached Files
    Thanks,

    R.



  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
    7,175

    Re: Conditional Formatting for blank cells with dependency on other cell

    whats you example of a formula verses a value
    if a formula returns a value - does that count

    you dont give an expected results in your sample

    you can use ISFORMULA ()
    to test if a cell has a formula - all your cells in A are true as you have
    =1
    =2
    etc

    so none would be conditional formatted


    if cell a2 has a value, (ignore formula) and b2 is blank, highlight b2 in red. I want to apply the formula to the whole column (A) but if a100 has no value, I don't want b100 to highlight in red...
    =AND($A2<>"", NOT(ISFORMULA($A2)),$B2<>"")

    I have removed the = from some of the values in A

    and also added some where B is blank

    see if these are the results you want
    Attached Files Attached Files
    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.

  3. #3
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    748

    Re: Conditional Formatting for blank cells with dependency on other cell

    thank you etaf, Il`l use this solution!

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

    Re: Conditional Formatting for blank cells with dependency on other cell

    you are welcome

+ 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] How to fill in blank cells with conditional formatting dependent on another cell
    By rowena229 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-23-2021, 02:29 PM
  2. Conditional formatting, based on non-blank cell from list of cells
    By rayted in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-15-2020, 08:01 AM
  3. conditional formatting based on another cell & leave blank cells
    By Gall47 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-31-2020, 10:58 AM
  4. [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
  5. conditional formatting of cells unless cell is blank
    By Dartherp in forum Excel General
    Replies: 0
    Last Post: 03-14-2014, 06:01 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. Replies: 3
    Last Post: 11-03-2009, 03:06 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