Results 1 to 2 of 2

Conditional Formatting a cell based on an entry into another cell

Threaded View

  1. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Conditional Formatting a cell based on an entry into another cell

    A date is a number, so...

    =ISNUMBER(B1)

    But make sure this condition is above the red one.

    For your next thread, check out all the options for sub forums and pick the one that relates to the question asked.

    This sub forum is, "Introduce yourself"

    Edit: Thread moved to Worksheet Functions sub-forum.
    Last edited by Paul; 05-25-2012 at 06:45 PM.
    HTH
    Regards, Jeff

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