+ Reply to Thread
Results 1 to 2 of 2

Change Background Color If date changes

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,078

    Change Background Color If date changes

    hi,
    i have column(A) with date, i want to set different background color for different date,

    different date limit are 4,

    i mean if in column(a) i have 24/02/21 then 25/02/21, 26/02/21 and 27/02/21 will be there
    or
    04/01/21, 05/01/21, 06/01/21 and 07/02/21 will be there

    just show different color background color for each date

    thaks
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,404

    Re: Change Background Color If date changes

    Say the dates start in A2, the CF rules for A2 (one for each colour) are:

    =A2=A$2
    =A2=A$2+1
    =A2=A$2+2
    =A2=A$2+3

    Apply each to the full range in A that you need formatted.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. change background textbox color based on text color in cell
    By atadaliran in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2021, 05:34 AM
  2. Change UserForm background color when a date is filled in
    By ProfXer in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-26-2018, 02:22 PM
  3. Replies: 8
    Last Post: 04-02-2016, 04:00 AM
  4. Change cell background color based on another cells background color
    By Queo in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 06-10-2014, 05:28 AM
  5. [SOLVED] Macro to change all cells with a certain background color in another background color
    By kevinvzandvoort in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2012, 11:04 AM
  6. [SOLVED] how can I conditionally change font color, or background color?
    By MOHA in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2006, 01:57 PM
  7. Replies: 5
    Last Post: 05-17-2006, 03:00 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