+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : 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

    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

+ Reply to 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