Results 1 to 5 of 5

Conditional Formatting Exception Based on Adjacent Column

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-16-2020
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    171

    Conditional Formatting Exception Based on Adjacent Column

    This is quite a simple objective (I think), but I can't seem to make it work reliably.

    In the attached spreadsheet, column J contains a due date. Right now, the conditional formatting formula turns it yellow if the date listed is within the next 30 days.

    I need to keep that functionality, but disable it only if the adjacent "Report Status" column is listed as "Complete"

    Many thanks for any help!
    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 Formatting Based On Adjacent Fields
    By christycoz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-28-2017, 04:14 PM
  2. Replies: 5
    Last Post: 07-12-2013, 01:15 AM
  3. [SOLVED] Conditional Formatting Columns Based on Text from Adjacent Column
    By mejiamang in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-18-2012, 10:41 PM
  4. Conditional formatting based on cell value in an adjacent column using VBA
    By Mistweaver in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-31-2012, 06:17 PM
  5. Conditional Formatting based on Adjacent Cell
    By MacroPolo in forum Excel General
    Replies: 3
    Last Post: 06-23-2012, 01:41 AM
  6. Conditional Formatting Based on Adjacent Cell
    By Yourgurlwantsme in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2010, 05:31 PM
  7. [SOLVED] How to do a conditional formatting based on an adjacent cell
    By Confused in forum Excel General
    Replies: 2
    Last Post: 01-10-2005, 06:06 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