Results 1 to 5 of 5

Color changing

Threaded View

  1. #1
    Registered User
    Join Date
    01-27-2009
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    54

    Color changing

    Hi, I am trying to have a row change colors based on a certin cell value
    I.E if the one Cell is greater then x then the Row 2 changed red.

    In the file you can see the "Time Now" will update automaticly and there is a user defined entry of time depicting what time the case was done.. the text thats read is the "Hidden" text and it help me get a value to determine the time differnece between the The "Time now" and the User defined time. at some point the differnce will be greater then 3 hours that is when i want the row to change from white to red.

    also once thats in effect i want i want the first rule to be ignored once the case is complete.
    And thoughts?

    [email protected]
    Last edited by k2hunter; 02-12-2009 at 12:51 AM.

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