Results 1 to 4 of 4

Partial conditional formatting based on the colour of a cell

Threaded View

  1. #1
    Registered User
    Join Date
    07-02-2014
    Location
    Germany
    MS-Off Ver
    MS Professional Plus 2010
    Posts
    2

    Question Partial conditional formatting based on the colour of a cell

    Is it possible to change the automatic formatting of a cell based on the colour of it?

    What I have until now (will attach a partial copy of the file):

    I have managed to enter formulae that one just has to change the year at the top of the page and it changes all the months and days in the remainder of the calendar. Weekends are grayed out.


    My aim:
    I would like the calendar to still as it does, change the dates based on the year appropriately including the leap years (as it does), but additionally ----> I would like the dates to have a,b,c,d,e,f,g,h after the days Mon-Fri consecutively over and over again - but IF i change the fill of the cell (any colour, or grey), for it to skip those days from the A-H cycle (aka weekends and random holidays).

    I will attach a file with a partial of what I have and an example of what I would like. (labelled on the side)

    If anyone could figure this out I would be unimaginably grateful as I think it MUST be necessary as it is possible to change the colour of the cell depending on the value, so it must be possible the other way? But whether it is possible for a part of the cell as well, I don't know. I will be forever in your debt! ;P How this debt will be repaid will be news to me however, other than that you will have a fellow player in the world who is just a little bit more intelligent thanks to you.
    Attached Files Attached Files
    Last edited by ello2001; 07-07-2014 at 02:46 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditional Formatting for Chart Series Based on Cell Colour
    By benjthom in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2013, 05:32 AM
  2. [SOLVED] Change cell colour based on text being present - conditional formatting?
    By rob-the-randy-rascal in forum Excel General
    Replies: 8
    Last Post: 08-01-2013, 11:24 AM
  3. [SOLVED] Conditional Formatting to Change Cell Colour Based on Date
    By Kym2101 in forum Excel General
    Replies: 5
    Last Post: 05-01-2012, 11:41 PM
  4. conditional formatting based on cell colour
    By nervous_pilchard in forum Excel General
    Replies: 0
    Last Post: 07-12-2011, 05:29 AM
  5. conditional formatting to change colour of cell based on formula result
    By gideong in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-15-2009, 09:35 AM

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