Conditional Formatting Blank Cells

[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

[staticbob]

Hey Carly,

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

=isblank(F11) or your cell obviously.

HTH
Bob

[Carly]

Thats brilliant thanks.

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

[staticbob]

=NOT(ISBLANK(A1))

Bob

[Carly]

Thanks that's helped me a great deal!

[Zack Barresse]

or simplify to two statements rather than two functions:

=ISBLANK(A1)=TRUE

=ISBLANK(A1)=FALSE

[Yogi Anand]

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.

[allana13]

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