+ Reply to Thread
Results 1 to 5 of 5

Conditional Formatting based on another cells Conditional Formatting

  1. #1
    Registered User
    Join Date
    08-15-2014
    Location
    Denmark
    MS-Off Ver
    365 Pro
    Posts
    77

    Conditional Formatting based on another cells Conditional Formatting

    Hi

    For the attached sheet, I'm trying to create a system that marks todays date in cell O4 with green in the table, and any date before that date with red. But I also want the cell to the right of the dates in the table to be marked with the same color as the ones in conditional formatting.

    If possible, I need it to be done without VBA.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-09-2019
    Location
    Ha nam, Vietnam
    MS-Off Ver
    2010
    Posts
    13

    Re: Conditional Formatting based on another cells Conditional Formatting

    check attach file
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-15-2014
    Location
    Denmark
    MS-Off Ver
    365 Pro
    Posts
    77

    Re: Conditional Formatting based on another cells Conditional Formatting

    Quote Originally Posted by tranhieu04 View Post
    check attach file
    It is the empty cells to the right of the dates that I need to follow the same conditional formatting. Eg. if date is August 22nd, 22 is marked green along with cell E12 to the right of 22 in the table. Same goes for dates before todays date, but in red.

    Just to clarify, this is what it is supposed to look like

    Attachment 638277

  4. #4
    Registered User
    Join Date
    08-09-2019
    Location
    Ha nam, Vietnam
    MS-Off Ver
    2010
    Posts
    13

    Re: Conditional Formatting based on another cells Conditional Formatting

    hi,

    I'm not good at Eng, maybe wrong.
    i make again with 2 condition fomatting. Check file to more detail
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-15-2014
    Location
    Denmark
    MS-Off Ver
    365 Pro
    Posts
    77

    Re: Conditional Formatting based on another cells Conditional Formatting

    Quote Originally Posted by tranhieu04 View Post
    hi,

    I'm not good at Eng, maybe wrong.
    i make again with 2 condition fomatting. Check file to more detail
    Works perfectly - Just what I needed :-) Thank you!

+ 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. Replies: 1
    Last Post: 10-04-2016, 05:17 AM
  2. Replies: 1
    Last Post: 08-19-2016, 03:57 PM
  3. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  4. [SOLVED] Conditional formatting based on another cells value
    By Mistweaver in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2012, 12:17 AM
  5. Replies: 4
    Last Post: 01-06-2012, 05:07 PM
  6. Conditional Formatting Based on Several Cells
    By dlvgolf in forum Excel General
    Replies: 2
    Last Post: 09-12-2008, 03:58 PM
  7. Conditional Formatting based on other cells
    By userzero in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-06-2006, 06:20 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