Closed Thread
Results 1 to 3 of 3

Several Conditional Formatting only working on some

  1. #1
    Registered User
    Join Date
    01-20-2009
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    3

    Smile Several Conditional Formatting only working on some

    ok Little back ground on the situation. I have a spreadsheet that i am tracking some Training dates on. i have the requirements written in the box categorgy on the attachement if anyone wants to see it. Ok so so far in the B colum (contains date of a computer based training (CBT))i have this conditional formatting:

    Formats for Red background
    Please Login or Register  to view this content.
    Formats for Yellow Background
    Please Login or Register  to view this content.
    Now i tried to add third one to the B colum to make the cell have no fill if the cell was empty. I cant figure out the formula for that.

    -----------------------------------------------------------
    Next
    in the C colum (contains date of in-class of colum B CBT) i want the formatting to show green with in 60 days of the date in colum B. It currently does that however. If there is no date in colum B it still shows green and I cant have that. Also if the Date in Colum C is the same date as Colum B, colum C still shows red. I need that to show green even though it is within the time frame. Here is the conditional formatting i have on the C colum

    Formats it to red
    Please Login or Register  to view this content.
    --------------------------------------------------------------

    Just a question. On the attachment if i make the conditional formatting code for B2
    Please Login or Register  to view this content.
    and in the applies to block and set it to the entire row is that ok to do? Will it generate the code for those following cells also?

    Thank you so much in advanced. I have been trying to do it for about a week now on my own but now im turning to fellow computer ppl
    Attached Files Attached Files
    Last edited by joblinger; 01-20-2009 at 05:17 PM. Reason: Moved to 2007 Forum

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    either post this in the 2007 forum or post an xls version i cant open this even with a converter

  3. #3
    Registered User
    Join Date
    01-20-2009
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    3
    Moved to 2007 forum......please close.

Closed Thread

Thread Information

Users Browsing this Thread

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

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