# 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. ## 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. Hey Carly,

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

HTH
Bob

3. ## Re: Conditional Formatting Blank Cells

Thats brilliant thanks.

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

4. =NOT(ISBLANK(A1))

Bob

5. ## Re: Conditional Formatting Blank Cells

Thanks that's helped me a great deal!

6. or simplify to two statements rather than two functions:

=ISBLANK(A1)=TRUE

=ISBLANK(A1)=FALSE

7. ## Re: Conditional Formatting Blank Cells

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!

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

8. ## Re: Conditional Formatting Blank Cells

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. ## Re: Conditional Formatting Blank Cells

Originally Posted by allana13

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. ## 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

#### Posting Permissions

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