Results 1 to 3 of 3

How to make this date conditional formatting

Threaded View

  1. #1
    Registered User
    Join Date
    06-25-2014
    Location
    Bulgaria
    MS-Off Ver
    2013
    Posts
    44

    How to make this date conditional formatting

    Hallo,

    A1 cell and B1 cell are in data format. B1 cell contains a simple formula - "=A1+30" as for one month ahead.

    What I want is when this date comes the cell (or up to ten cells in the same row nex to each other, if possible) to appear different colour. Red for example. I'm attaching an example.

    Thank You
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Make conditional formatting static
    By alice2011 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-20-2018, 06:50 AM
  2. [SOLVED] Conditional Formatting: If Date is ____ Make subsequent rows turn color
    By morerockin in forum Excel General
    Replies: 1
    Last Post: 05-20-2015, 09:23 AM
  3. Conditional Formatting How to make the top 3?
    By GmOOnii in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-24-2013, 03:47 PM
  4. Replies: 7
    Last Post: 12-17-2010, 03:17 AM
  5. Conditional Formatting to make #N/A disappear
    By JulieChu in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-06-2010, 11:22 AM
  6. help to make moving conditional formatting
    By birkhe in forum Excel General
    Replies: 0
    Last Post: 05-19-2009, 05:25 AM
  7. Conditional formatting-how to make it happen?
    By Jonsson in forum Excel General
    Replies: 0
    Last Post: 04-02-2005, 03:55 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