+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting in a crowded with code cell

  1. #1
    Forum Contributor
    Join Date
    03-25-2011
    Location
    London, England
    MS-Off Ver
    office 2021
    Posts
    317

    Conditional formatting in a crowded with code cell

    Good Afternoon
    I have a Gantt chart built with endless help of this forum. I would like to make a small addition. I would like the cells for the day to alter colour. There is so much going on in the cell I am scared to muck with it.
    Thia
    HTML Code: 
    is cell when it is altered to blue because of the date entered in the chart is this date. I do not want to alter that but when the date is today and not being altered by the blue I would like it to be orange. so that at a glance anyone can see where today is.
    On the attached example i have the live chart, albeit 5 lines on the top and a graphic illustration of what i would like on the bottom. You can see the orange covering the cells which has nothing in them but not the ones which are blue because of the chart busy days.
    Hope this makes sense.
    Mark
    Attached Files Attached Files

  2. #2
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Conditional formatting in a crowded with code cell

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. Conditional Formatting to color-code 1 cell based on data in another field
    By Rhesa324 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-05-2019, 12:33 AM
  2. Over crowded pie
    By zunz in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-23-2019, 11:06 PM
  3. [SOLVED] VBA Code For Conditional Formatting, cell that Contains...
    By Darrellcoholic in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-18-2014, 04:25 AM
  4. Replies: 5
    Last Post: 12-07-2013, 02:21 PM
  5. Excel 2007 : Crowded tabs when splitting sheet
    By RAGUS in forum Excel General
    Replies: 1
    Last Post: 02-28-2012, 06:52 PM
  6. Conditional Formatting Code - Deletes Wrong Conditional Format
    By RSpecianJr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2010, 10:53 AM
  7. conditional formatting:How can I rate a cell 1-5 and colour code it?
    By treetop40 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2005, 08:05 AM

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