+ Reply to Thread
Results 1 to 13 of 13

Conditional formatting on dates if another cell equals to

Hybrid View

  1. #1
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2511 (Windows 11 Home 24H2 64-bit)
    Posts
    92,890

    Re: Conditional formatting on dates if another cell equals to

    Yes, but you haven't answered my question, really: what do you want it to do?

    I'm good, but I'm not a mind-reader ...
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Volunteer organiser & photographer with the Sutton Hoo Ship's Company: https://saxonship.org/
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

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

    Re: Conditional formatting on dates if another cell equals to

    I want the sheet to color the cells in the calendar marked with S, M and F, and only the cells that contains those letters. If the cells under column "D" is marked with Cell1, then it should color the cells in the calendar that have already been filled with text, red. if the cells under column "D" is marked with Cell2, then it should color the cells in the calendar with yellow and if it's marked with Cell3, it should color it orange. is that understandable or should try and explain it in a different way?

+ 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: 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