+ Reply to Thread
Results 1 to 4 of 4

Conditional Formating Based on Select Cells Above

  1. 02-08-2019, 04:51 AM #1
    DarkNiiinja
    DarkNiiinja is offline
    Registered User
    Join Date
    02-08-2019
    Location
    Washington State, USA
    MS-Off Ver
    2019
    Posts
    2

    Conditional Formating Based on Select Cells Above

    Hello.

    I am trying to make a single cell orange if any of the cells above it are empty. How can I do that?

    Thank you so much for your time in advance!
    Reply With QuoteRegister To Reply
  2. 02-08-2019, 04:53 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Conditional Formating Based on Select Cells Above

    Hi, welcome to the forum

    You dont give us much to work with

    Assuming the cell you want to change is A20, and you are resting all the cells above, perhaps this?
    =countif(A1:A19,"")>0
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 02-08-2019, 04:58 AM #3
    DarkNiiinja
    DarkNiiinja is offline
    Registered User
    Join Date
    02-08-2019
    Location
    Washington State, USA
    MS-Off Ver
    2019
    Posts
    2

    Re: Conditional Formating Based on Select Cells Above

    Yes! That worked!! Thank you so much!!
    Brilliant!
    Reply With QuoteRegister To Reply
  4. 02-08-2019, 05:03 AM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Conditional Formating Based on Select Cells Above

    Happy to help and thanks for the feedback
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 two different cells
    By pepijnkr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2018, 05:19 AM
  2. [SOLVED] Conditional Formating Based On Other Cells Being Blank
    By kschmit1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-06-2016, 10:36 AM
  3. [SOLVED] Conditional Formating based on another cells value containing text and digits
    By mrteater in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-13-2015, 06:36 PM
  4. 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
  5. how do I apply conditional formating to a row of cells based on the value of only one cell
    By peche in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-09-2013, 03:55 PM
  6. hide cells based on conditional formating
    By djarcadian in forum Excel General
    Replies: 3
    Last Post: 04-01-2008, 09:43 PM
  7. 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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1