+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting to ignore blank cells 2003

Hybrid View

  1. #1
    Registered User
    Join Date
    07-12-2015
    Location
    Crewe
    MS-Off Ver
    Windows 7
    Posts
    1

    Conditional Formatting to ignore blank cells 2003

    I am sure this has been asked but I cannot find a reply that suits my simple requirement.

    I have a sheet that collates % scores over a 12 month period. I can apply conditional formatting easy enough colouring the cells red, amber or green based on a set criteria. however, as there are only 3 rules in 2003 i cannot get it to ignore the cells not yet filled in and as a result the remaining sheet is red?

    How can i apply a fourth rule or am i looking at using more complex formula?
    Please help

    Many thanks
    Colonelkaye

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,620

    Re: Conditional Formatting to ignore blank cells 2003

    I suppose you have a CF which says something like =A1<12% ( or whatever) that colors say red
    Just replace it by =AND(A1<>"",A1<12%) and format red.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting - ignore Blank Cells
    By therealtfloss in forum Excel General
    Replies: 1
    Last Post: 02-09-2015, 11:38 AM
  2. [SOLVED] Excel 2003 - conditional formatting not ignoring blank cells
    By Lloydiesuk in forum Excel General
    Replies: 2
    Last Post: 08-01-2013, 03:12 AM
  3. Replies: 5
    Last Post: 05-18-2013, 07:49 PM
  4. [SOLVED] How to get Conditional Formatting to ignore blank cells?
    By AndyHawke in forum Excel General
    Replies: 3
    Last Post: 08-22-2012, 08:25 AM
  5. How to ignore blank cells in conditional formatting?
    By Gooford in forum Excel General
    Replies: 5
    Last Post: 08-22-2012, 08:06 AM

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