+ Reply to Thread
Results 1 to 7 of 7

Conditional Formating Based On Other Cells Being Blank

  1. #1
    Forum Contributor
    Join Date
    09-08-2016
    Location
    Buffalo, NY
    MS-Off Ver
    365
    Posts
    115

    Conditional Formating Based On Other Cells Being Blank

    Hello All - I've had trouble finding a solution for my specific issue and have attempted a variety of conditional formatting methods with little to no success.

    In the attachment I am trying to force the user to fill in all the necessary fields before an end result registers. Those fields highlighted in yellow are "required" (Note: Aside from B15:16, it is really the calculation in B18 that is needed, anything input before it just calculates into a sum there).

    Based upon the fields input, preliminary results will be yielded in B18 and B30 (green highlight next to these cells), these values then translate to B34:B35 and final result of the larger of the two generates in B37. I do not want a value to register in B37 in red until both B34/35 have a value registered. Text should remain white until both fields have an entry.

    Help please!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Conditional Formating Based On Other Cells Being Blank

    I am not sure you need a conditional format

    in b37 =IF(AND(B15<>"",B16<>"",B28<>""),MAX(B34,B35),"")

    Regards

    Dav

  3. #3
    Forum Contributor
    Join Date
    09-08-2016
    Location
    Buffalo, NY
    MS-Off Ver
    365
    Posts
    115

    Re: Conditional Formating Based On Other Cells Being Blank

    I'm not sure I need conditional formatting either however even if I adjust your formula to be (B18 is really what becomes important, 16 could potentially be blank or there could be additional deposit lines added after it)

    =IF(AND(B18<>"",B28<>""),MAX(B34,B35),"")

    Not having much luck getting this to register a result, it registers b34 in b36 but as soon as b35 has content, b37 becomes blank. I want this to remain blank if either B34 or B35 are blank.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,594

    Re: Conditional Formating Based On Other Cells Being Blank

    If I understand post #1 then the following formula can be used as a conditional formatting rule applied to B37 to do what you want (keep the value in the cell hidden until all required fields are filled), as shown in the attached file:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Conditional Formating Based On Other Cells Being Blank

    =if(and(b18<>0,b28<>"",b22<>""),max(b34,b35),"")

  6. #6
    Forum Contributor
    Join Date
    09-08-2016
    Location
    Buffalo, NY
    MS-Off Ver
    365
    Posts
    115

    Re: Conditional Formating Based On Other Cells Being Blank

    Thank you JeteMC that seemed to do the trick, sorry davsth I'm still having some trouble with that formula working but I appreciate both responses!

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,594

    Re: Conditional Formating Based On Other Cells Being Blank

    You're Welcome. Thank you for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day

+ 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 based on calculations in other cells Help please
    By Darkprophecy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-28-2014, 11:08 AM
  2. Help with Conditional Formating based on adjacent cell not being blank
    By noplacelikehome in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-06-2014, 05:47 PM
  3. Replies: 4
    Last Post: 01-23-2014, 10:14 AM
  4. Conditional formating multiple cells based on blank or filled single cell.
    By turbotank in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-13-2012, 12:11 PM
  5. hide cells based on conditional formating
    By djarcadian in forum Excel General
    Replies: 3
    Last Post: 04-01-2008, 09:43 PM
  6. conditional formating cells i Excel based on other cells values
    By Elias Petursson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2006, 01:50 PM
  7. Use conditional formating to incicate blank cells in excel
    By AreaManager in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-07-2005, 02: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