Results 1 to 3 of 3

How to make the empty cell become yellow? (SOLVED)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-29-2005
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    253

    Question How to make the empty cell become yellow? (SOLVED)

    Hi,

    I have attached a sample here. If the profit is less than target, the target cell for that month will turn red and text turn yellow. After Apr, all of them are blank but my target becomes red due to the conditional format I put in the target column. How do I make these empty cell become yellow??
    Attached Files Attached Files
    Last edited by Lewis Koh; 06-04-2010 at 10:31 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