Results 1 to 5 of 5

Excel 2007/2010 Conditional/Formula Formatting multiple possible

Threaded View

  1. #1
    Registered User
    Join Date
    12-04-2008
    Location
    notta
    Posts
    21

    Excel 2007/2010 Conditional/Formula Formatting multiple possible

    Ok I have a spreadsheet that calculates schedule hours for a 2 week period of time/total of one month. So the box would have 80 / 80 if both pay periods were complete. If not it would be 48 / 80 or ## / ##. No of course when I first start making the schedule it is 0 / 0.

    In this COLUMN there are headings/other things in other places as well. IF possible I would like it to leave the box NO FILL when the value is 0 / 0, or any other text/blanks, etc.

    If it is ## / ## I would like it to FILL the box RED (basically highlighting that the hours are not complete, and then FILL GREEN when the value = 80 / 80 letting me know they are scheduled for their total hours of the month.

    So I can do conditional formatting with 80 / 80 and set it to FILL green, but if I do NOT EQUAL or anything else ofr the colors it wants to set ALL of them NOT equal to other colorrs...

    any help is appreciated...

    I was even going to just say FONT colors using CUSTOM FORMATTING
    [GREEN][="80 / 80"]## / ##;[Black][="0 / 0"]# /#;[RED]## / ##

    but that didn't work... for some reason keeps changing the values to 80 or 0 and ignoring it... I guess that custom formatting only goes with greater than numbers, etc
    Last edited by ExcelNoob2008; 06-16-2011 at 11:42 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