Results 1 to 13 of 13

Conditional formating formula

Threaded View

jacko311 Conditional formating formula 02-02-2010, 10:40 AM
ChemistB Re: Conditional formating... 02-02-2010, 10:45 AM
NBVC Re: Conditional formating... 02-02-2010, 10:46 AM
martindwilson Re: Conditional formating... 02-02-2010, 10:46 AM
martindwilson Re: Conditional formating... 02-02-2010, 10:47 AM
jacko311 Re: Conditional formating... 02-02-2010, 10:54 AM
jacko311 Re: Conditional formating... 02-02-2010, 11:06 AM
NBVC Re: Conditional formating... 02-02-2010, 11:21 AM
jacko311 Re: Conditional formating... 02-02-2010, 11:35 AM
NBVC Re: Conditional formating... 02-02-2010, 11:40 AM
jacko311 Re: Conditional formating... 02-02-2010, 11:44 AM
NBVC Re: Conditional formating... 02-02-2010, 12:00 PM
jacko311 Re: Conditional formating... 02-02-2010, 12:04 PM
  1. #1
    Registered User
    Join Date
    04-07-2009
    Location
    Lakewood, Wa
    MS-Off Ver
    Excel 2007
    Posts
    39

    Conditional formating formula

    I would like to have a cell's fill color change if the following conditions are met (I will use cell D1 as the cell to fill):

    if cell B1 (which has a date as its value) = today's date AND cell F1 = BO

    My problem was using an if/and function that looks at B1 to see if it is today's date but cant figure that out. Any help would be appreciated.
    Last edited by jacko311; 02-02-2010 at 12:04 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