Results 1 to 4 of 4

Conditional Formatting Between Two Dates ?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-03-2010
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    Excel 2013
    Posts
    135

    Conditional Formatting Between Two Dates ?

    Hi to all Experts,

    Actually the question i am asking its seems very easy/simple but i do not know where i am doing wrong.

    i am trying to define a conditional formatting between two dates which is like this :

    if Date in Cell H7 is less then Date in Cell H6 then my font should be red and if Cell H7 Date is higher then H6 then font should be green.

    to define this i tried =AND($H7<$H6) & =AND($H7>=$H6) but my all cells getting same color.

    for better idea i attached the example sheet as well.

    thanks in advance.....hope i cleared my self
    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] Multi-Conditional Conditional Formatting and Dates
    By Mousiefuzz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2015, 04:09 AM
  2. Conditional formatting using dates and using dates without years
    By dcef79 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-15-2014, 05:35 AM
  3. Replies: 11
    Last Post: 05-04-2014, 08:28 PM
  4. [SOLVED] Conditional Formatting Due dates and Completed Dates
    By shansen79 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-30-2014, 01:33 PM
  5. Conditional Formatting with approaching due dates and completed dates
    By rogernation in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-13-2013, 04:12 PM
  6. Replies: 4
    Last Post: 08-29-2013, 11:23 AM
  7. [SOLVED] Conditional Formatting of: dates within 1 month and dates before today.
    By Luke Smith in forum Excel General
    Replies: 5
    Last Post: 06-18-2013, 07:29 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