Results 1 to 13 of 13

Conditional formatting on dates if another cell equals to

Threaded View

  1. #1
    Registered User
    Join Date
    04-10-2019
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2016
    Posts
    12

    Conditional formatting on dates if another cell equals to

    Hi,

    I'm currently making a production planning sheet, and i have just reached a point where i'm facing some problems.

    I have attached a picture of the sheet, so that my explanation of my problem is easier to understand.

    My sheet books time in the calender for each production order based on dates, that works fine. Now i want to assign different production cells to each production order, and if i for instance type cell1 one in one of the cells under "PO assigned to cel", then i want to make the sheet automatically color the booked dates in calender with a given color. so far i have only been able to color the whole row red, i want it to only color the booked dates in the calendar.

    If anybody could help on this matter, i would be very happy.
    Attached Files Attached Files
    Last edited by Mikkel_pet; 07-15-2019 at 05:14 AM.

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: 03-21-2019, 05:26 PM
  2. [SOLVED] Highlight Cell (Conditional Formatting or VBA Worksheet event) equals cell - BINGO tracker
    By jhoelski in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-25-2017, 08:32 PM
  3. [SOLVED] Conditional formatting for dates in another cell
    By NMDIVA in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 01-18-2017, 07:19 PM
  4. [SOLVED] Conditional formatting - equals multiple values
    By butlerar in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-20-2015, 04:17 PM
  5. Conditional formatting - highlight range of cells when it equals a cell
    By kingkong321 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2012, 05:13 AM
  6. IF Dates and conditional formatting (cell colours)
    By aluniquen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-28-2012, 04:32 AM
  7. Replies: 3
    Last Post: 08-16-2011, 09:13 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