+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting - Detecting dates among other data + boldface

  1. #1
    Registered User
    Join Date
    06-19-2017
    Location
    Portland
    MS-Off Ver
    2013
    Posts
    1

    Smile Conditional Formatting - Detecting dates among other data + boldface

    Hi all,

    I am brand new to VBA programming and I'm not finding a solution to my problem using just formulas (although if there is a way to do this, I think it would be preferred).

    I have a spreadsheet where I track appointments and I input the appointment title and date in BOLD once it is scheduled (e.g. "C1D22 6/20/17"). I use this to track data entry for a research study, so every patient has a series of appointments over time. These I add manually to my spreadsheet horizontally. Each patient is listed vertically in column G.

    What I want my spreadsheet to do is this:

    1. Detect when a cell to the right of G# meets these two conditions: is BOLDFACE *and* contains a date that is in the past.
    2. Any date in bold AND 1-8 days old, I want to turn ORANGE
    3. Any date in bold AND 9+ days old, I want to turn RED
    4. If I turn the cell any other color manually (like green or yellow) or if I remove the boldface, I want this to override the above rules.
    5. Finally, I want the cell in column G that contains patient initials to turn the corresponding color if ANY cells to the right contain the following (in this order):

    - IF any are RED, make initials RED
    - If no red but ORANGE, make initials ORANGE
    - IF no orange or red, but YELLOW (manually colored yellow), make initials Yellow.
    - IF no color or if only GREEN, make initials GREEN.

    Thank you for any help!

    ExcelQuestion.JPG

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Conditional Formatting - Detecting dates among other data + boldface

    You don't show initials in column G ?

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    853

    Re: Conditional Formatting - Detecting dates among other data + boldface

    Have you tried doing this with Conditional Formatting?

    And perhaps post a sample to start with?

+ 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. [SOLVED] Detecting 2 substrings in cell with conditional formatting.
    By Ethan! in forum Excel General
    Replies: 4
    Last Post: 06-03-2017, 05:42 AM
  2. Replies: 11
    Last Post: 05-04-2014, 08:28 PM
  3. Replies: 4
    Last Post: 08-29-2013, 11:23 AM
  4. Detecting if a cell has conditional formatting applied to it
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2013, 01:37 PM
  5. Conditional Formatting and detecting the state of a specific cell
    By sir.york in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-18-2013, 09:24 AM
  6. Detecting conditional formatting
    By RJH in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-06-2006, 02:15 PM
  7. Replies: 1
    Last Post: 01-29-2006, 06:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1