Results 1 to 7 of 7

Conditional formatting to treat formula as blank

Threaded View

anglarna_ger Conditional formatting to... 08-24-2017, 06:11 PM
leelnich Re: Conditional formatting to... 08-24-2017, 07:54 PM
anglarna_ger Re: Conditional formatting to... 08-26-2017, 04:57 PM
leelnich Re: Conditional formatting to... 08-27-2017, 12:26 AM
anglarna_ger Re: Conditional formatting to... 08-28-2017, 07:13 PM
leelnich Re: Conditional formatting to... 08-28-2017, 07:54 PM
anglarna_ger Re: Conditional formatting to... 08-29-2017, 03:45 PM
  1. #5
    Registered User
    Join Date
    08-16-2009
    Location
    glasgow
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Conditional formatting to treat formula as blank

    sample attached.

    Needs to be no formatting if there are no results for that week, green if someone has picked a winner that week and red if they haven't.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Treat a Formula as a Blank Cell
    By JimS in forum Excel General
    Replies: 2
    Last Post: 01-20-2009, 12:03 AM
  2. [SOLVED] Lookup formula - treat no-registered cells as blank
    By gublues in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 06:05 AM
  3. [SOLVED] Lookup formula - treat no-registered cells as blank
    By gublues in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  4. [SOLVED] Lookup formula - treat no-registered cells as blank
    By gublues in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. [SOLVED] Lookup formula - treat no-registered cells as blank
    By gublues in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. [SOLVED] Lookup formula - treat no-registered cells as blank
    By gublues in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. [SOLVED] Lookup formula - treat no-registered cells as blank
    By gublues in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  8. [SOLVED] Lookup formula - treat no-registered cells as blank
    By gublues in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2005, 06:05 PM

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