+ Reply to Thread
Results 1 to 16 of 16

Condtional Formatting

Hybrid View

  1. #1
    Registered User
    Join Date
    05-20-2014
    Posts
    6

    Re: Condtional Formatting

    Thanks, but you looked at the incorrect file. It was my fault as I added both in error.

    On the one I've attached again below, Column F has the date the response is received. As this is exceeds 14 days and it does not appear to have been assessed (no date in column G), I would like the date text (in column F) to turn red.

    I don't want the cell in column G to turn red.

    The date in column F would then return to black once a date is added into column G.

    I hope this makes sense.
    Attached Files Attached Files

+ 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. Condtional Formatting
    By iamtehwalrus in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 04-19-2010, 11:25 PM
  2. condtional formatting
    By keith6292 in forum Excel General
    Replies: 2
    Last Post: 10-28-2009, 12:43 PM
  3. Condtional formatting
    By gandolff in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-09-2009, 08:58 PM
  4. condtional formatting help
    By diesel20056 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2006, 11:16 AM
  5. Condtional formatting
    By 68magnolia71 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-15-2005, 05:06 PM

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