+ Post New Thread
Results 1 to 2 of 2
Coding Thread, colour a cell in excel for a time period in Coding and Web Development; i currently have a spreadsheet that has a column with only the characters ? [ and E in it, these ...
  1. #1

    Join Date
    Apr 2012
    Location
    scotland
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    colour a cell in excel for a time period

    i currently have a spreadsheet that has a column with only the characters ? [ and E in it, these characters are changed to reflect the availabilty of work, is it possible to have a cell change colour for a period of time (approx 30 mins) when one of the characters is changed to another...e.g if a cell changes from ? to a [ i would like it to fill in red.

    i am pretty new to the whole excel formatting and would appreciate any assitance on this matter!!

    thank you in advance

  2. #2

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,403
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    168
    Getting the cell to change colour based on contents is easy...just use conditional formatting...but...you would need to manually refresh the sheet to update the colour.

    ...getting the colour to change back after a time interval would most probably need some vba script...

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 3
    Last Post: 16th January 2012, 08:50 AM
  2. Replies: 1
    Last Post: 15th December 2011, 12:31 PM
  3. Replies: 30
    Last Post: 14th September 2011, 10:05 PM
  4. colour laser all in one for home
    By joe90bass in forum Hardware
    Replies: 11
    Last Post: 6th November 2008, 11:07 PM
  5. VB code to colour cells in a word table
    By park_bench in forum Coding
    Replies: 4
    Last Post: 30th June 2008, 08:52 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •