Results 1 to 10 of 10

Conditional Formatting Blank Cells

This is a discussion on Conditional Formatting Blank Cells within the Excel Questions forums, part of the Question Forums category; Can anyone help? I am trying to conditional format a blank cell to fill RED, can this be done? I ...

  1. #1
    Board Regular Carly's Avatar
    Join Date
    Aug 2002
    Location
    Hull - England
    Posts
    368

    Default Conditional Formatting Blank Cells

    Can anyone help?

    I am trying to conditional format a blank cell to fill RED, can this be done?

    I have tried cell value = "" but it doesn't like this!

    Kind Regards
    Carly

  2. #2
    Board Regular staticbob's Avatar
    Join Date
    Oct 2003
    Location
    Manchestershire
    Posts
    1,079

    Default

    Hey Carly,

    Use a formula rather than "Cell is" and just type

    =isblank(F11) or your cell obviously.

    HTH
    Bob
    "I dislike 7 am. If 7 am were a person, I would punch 7 am in the biscuits." - Paul Ryan, Dailyramblings.com

  3. #3
    Board Regular Carly's Avatar
    Join Date
    Aug 2002
    Location
    Hull - England
    Posts
    368

    Default Re: Conditional Formatting Blank Cells

    Thats brilliant thanks.

    How can I now say if it has something in it (i.e. IsNotBllank)?

  4. #4
    Board Regular staticbob's Avatar
    Join Date
    Oct 2003
    Location
    Manchestershire
    Posts
    1,079

    Default

    =NOT(ISBLANK(A1))

    Bob
    "I dislike 7 am. If 7 am were a person, I would punch 7 am in the biscuits." - Paul Ryan, Dailyramblings.com

  5. #5
    Board Regular Carly's Avatar
    Join Date
    Aug 2002
    Location
    Hull - England
    Posts
    368

    Default Re: Conditional Formatting Blank Cells

    Thanks that's helped me a great deal!

  6. #6
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,399

    Default

    or simplify to two statements rather than two functions:

    =ISBLANK(A1)=TRUE

    =ISBLANK(A1)=FALSE
    Regards,
    Zack Barresse
    Excel & Access blog
    All Excel Functions
    Training
    (If you would like comments in any code, please say so.)

  7. #7
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454

    Default Re: Conditional Formatting Blank Cells

    Quote Originally Posted by Carly
    Can anyone help?

    I am trying to conditional format a blank cell to fill RED, can this be done?

    I have tried cell value = "" but it doesn't like this!

    Kind Regards
    Carly
    Hi Carly:

    in reference to using Cell Value Is

    Cell Value Is equal to ="" did work for me!

    chances are you had used:

    Cell Value Is equal to "" that will not work.
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  8. #8
    New Member
    Join Date
    Mar 2010
    Posts
    3

    Default Re: Conditional Formatting Blank Cells

    This is helpfull

    However i have a question on my conditional formatting

    if cell value is between 1 and 2.4 colour = amber
    if cell value is less than 1 colour = red
    If the cell value is grater then 2.4 it has to be green
    however if cell has no value in it it needs to be white.

    Any help on that conditonal formatting please

    Thanks

  9. #9
    New Member
    Join Date
    Jul 2013
    Posts
    1

    Default Re: Conditional Formatting Blank Cells

    Quote Originally Posted by allana13 View Post
    This is helpfull

    However i have a question on my conditional formatting

    if cell value is between 1 and 2.4 colour = amber
    if cell value is less than 1 colour = red
    If the cell value is grater then 2.4 it has to be green
    however if cell has no value in it it needs to be white.

    Any help on that conditonal formatting please

    Thanks

    Hi,

    I have the same issue.
    In Conditional Formatting open "Use formula to determine which cells to format"
    here you can type "=IFBLANK(??)" and select the cells you want to consider...
    Finally in Preview you select Format - Fill - No Color
    PS: if you type the cell N16 between the brackets, all the conditional formatting range will refer to cell N16, if you select the cell from spreadsheet, it will automatically update row and column...

    regards

    Simone

  10. #10
    New Member
    Join Date
    Sep 2013
    Posts
    1

    Default Re: Conditional Formatting Blank Cells

    Try this:
    1. Select cells you want to format
    2. On Home Ribbon go to Conditional Formatting --> Highlight Cells Rules --> More Rules...
    3. In "New Formatting Rule" pop-up select "Format only cells that contain" option from "Select a Rule Type:" section
    4. In same pop-up window select "Blanks" options from drop-down-list given under "Edit the Rule Description:" section
    5. Again, in same pop-up window click "Format.." button to define type of formatting you wish and click "Ok" to close window
    ~Umang

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com