Results 1 to 7 of 7

Conditional Formating Based On Other Cells Being Blank

Threaded View

kschmit1 Conditional Formating Based... 12-05-2016, 12:55 PM
davsth Re: Conditional Formating... 12-05-2016, 01:19 PM
kschmit1 Re: Conditional Formating... 12-05-2016, 02:04 PM
JeteMc Re: Conditional Formating... 12-05-2016, 09:06 PM
davsth Re: Conditional Formating... 12-06-2016, 05:05 AM
kschmit1 Re: Conditional Formating... 12-06-2016, 09:13 AM
JeteMc Re: Conditional Formating... 12-06-2016, 10:36 AM
  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

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. [SOLVED] 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