Results 1 to 60 of 60

changing font color based on change actual number in a table

Threaded View

  1. #27
    Forum Contributor
    Join Date
    05-16-2010
    Location
    UK
    MS-Off Ver
    2003 and 2007
    Posts
    252

    Re: changing font color based on change actual number in a table

    Yes, I'm in England.

    Just so I have it clear in my mind:

    It is a visual record of what has been cleaned against what should be cleaned. Therefore, if the values entered in the 12 worksheets (what has been cleaned) are different to the template worksheet (what should be cleaned) then the font will go red (or some different colour). In which case, are you only looking at values less than the template values?

    I environmental inspection and must assess how much was done cleaning the city.
    Would you not want to look at something like the percentage cleaned against the target also?

    Some of the values below the table are 0. Does this mean cleaning is not required?

    Will the new workbook be translated?

    ...and your English is far better than my Romanian.

    EDIT:
    Would you also want to stop values greater than the area that should be cleaned from being entered ... or is there no need to do this because the performance is bonus related?
    Last edited by pb71; 07-06-2010 at 04:49 PM.

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