Results 1 to 3 of 3

Apply conditional formatting to a cell when it is left BLANK

Threaded View

  1. #1
    Registered User
    Join Date
    11-30-2008
    Location
    Brisbane, Australia
    Posts
    2

    Red face Apply conditional formatting to a cell when it is left BLANK

    Hi Fellow Excellers,

    I'm trying to apply conditional formatting (shading) to cells that are left blank.

    (Purpose: I am designing a research template for a client to complete with data and want the spreadsheet to show them where they've "missed a bit"!)

    Does anyone know how to do this?

    (When I go to the conditional formatting box, it asks me to specify when "cell value is"..."between/not between/equal to/not equal to" etc. But there's no option to specify when the cell is blank.)

    Thank you!

    Rach
    Last edited by NBVC; 11-30-2008 at 11:17 PM. Reason: typo: data (not date!)

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