Results 1 to 6 of 6

using conditional formatting to match MONTH

Threaded View

  1. #4
    Forum Contributor
    Join Date
    06-22-2010
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2003
    Posts
    152

    Re: using conditional formatting to match MONTH

    Thanks. Here is the sample file. I will have no control over people entering data in the columns that are not highlighted. There is a danger they may leave a blank cell or use the wrong format. i would like to place a conditional format in column H that would highlight problems like the one at H20 which is caused by a blank cell in column E. It would also check for any other errors that may occur with people copying and pasting cells and possibly knocking out the formulas. This is to give the users an immediate notification to rectify their entry.

    I will try the example you have given above.

    Thanks
    Attached Files Attached Files

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