+ Reply to Thread
Results 1 to 3 of 3

How can I refer to a blank cell when using conditional formating?

  1. #1
    Kman
    Guest

    How can I refer to a blank cell when using conditional formating?

    I want to make a conditional format that will leave the cell unchanged if the
    cell involved is blank.

  2. #2
    Toppers
    Guest

    RE: How can I refer to a blank cell when using conditional formating?

    Probably use an IF/AND condition

    Something like:

    Formula is: =IF(AND(A1<>"",A1=condition))

    HTH

    "Kman" wrote:

    > I want to make a conditional format that will leave the cell unchanged if the
    > cell involved is blank.


  3. #3
    Peo Sjoblom
    Guest

    Re: How can I refer to a blank cell when using conditional formating?

    If using conditional formatting testing for a non blank cell to this would
    suffice

    =A1<>""

    --

    Regards,

    Peo Sjoblom

    Excel 95 - Excel 2007
    Northwest Excel Solutions
    www.nwexcelsolutions.com
    "It is a good thing to follow the first law of holes;
    if you are in one stop digging." Lord Healey


    "Toppers" <Toppers@discussions.microsoft.com> wrote in message
    news:C4FD117D-C066-440A-8223-868A7D633747@microsoft.com...
    > Probably use an IF/AND condition
    >
    > Something like:
    >
    > Formula is: =IF(AND(A1<>"",A1=condition))
    >
    > HTH
    >
    > "Kman" wrote:
    >
    >> I want to make a conditional format that will leave the cell unchanged if
    >> the
    >> cell involved is blank.




+ 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