+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting a whole spreadsheet

  1. #1
    Registered User
    Join Date
    08-07-2009
    Location
    Dublin, California
    MS-Off Ver
    Excel 2003
    Posts
    18

    Conditional Formatting a whole spreadsheet

    Hello,

    I would like to apply the following formula of conditional formatting to my whole spreadsheet, but it doesn't seem to work.

    =ISBLANK($B$2)

    Instead I would like it to color all blank cells in my print area worksheet so wouldn't it read

    =ISBLANK($A$2:$V$1140)

    Why isn't it working?

    The following WON'T work either because once I copy and paste special I cannot add data to any blank cell without the whole lot turning back to white.

    Copy the cell A1
    Select the area that you want to apply the conditional formatting to
    Right click in that selected area and select "Paste Special"
    Select "Formats"

    Please help.

    Thank you,

    Danielle

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Conditional Formatting a whole spreadsheet

    Highlight the entire range first, then under conditional formatting custom, enter =ISBLANK(B2) without the dollar sign

+ Reply to Thread

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