If is blank= conditional formating

[Markitos]

Hello

I was trying to make a formula to conditional format a cell. I wanted the
formula to be (if the cell is blank). I wanted to make the cell have a red
border if it was blank. I know how to make make the border red if the
condition is true, but im not sure how to write the formula for this.

Thanks for your help.

[Jason Morin]

=$A$1=""

HTH
Jason
Atlanta, GA

>-----Original Message-----
>Hello
>
>I was trying to make a formula to conditional format a
cell. I wanted the
>formula to be (if the cell is blank). I wanted to make
the cell have a red
>border if it was blank. I know how to make make the
border red if the
>condition is true, but im not sure how to write the
formula for this.
>
>Thanks for your help.
>.
>

[Markitos]

Thanks for your answer it was of great help.
I found something rather hard though, I cant copy the formula to other
cells, I wanted a whole row to use this formula, but if I copy a cell to
others it doesn't change the formula to correspond with the new cell, its
leaving the cell # the same.

Thanks for your help.

"Jason Morin" wrote:

> =$A$1=""
>
> HTH
> Jason
> Atlanta, GA
>
> >-----Original Message-----
> >Hello
> >
> >I was trying to make a formula to conditional format a
> cell. I wanted the
> >formula to be (if the cell is blank). I wanted to make
> the cell have a red
> >border if it was blank. I know how to make make the
> border red if the
> >condition is true, but im not sure how to write the
> formula for this.
> >
> >Thanks for your help.
> >.
> >
>

[David McRitchie]

Hi Mark,
see http://www.mvps.org/dmcritchie/excel/condfmt.htm
you probably want to use a formula like =A1=""
or perhaps =TRIM(A1)=""
if A1 is the active cell in your selection when you do the Conditional Formatting.

$A1 would be good for coloring the entire row based on the cell in Column A.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Markitos" <[email protected]> wrote in message news:[email protected]...
> Thanks for your answer it was of great help.
> I found something rather hard though, I cant copy the formula to other
> cells, I wanted a whole row to use this formula, but if I copy a cell to
> others it doesn't change the formula to correspond with the new cell, its
> leaving the cell # the same.
>
> Thanks for your help.
>
> "Jason Morin" wrote:
>
> > =$A$1=""
> >
> > HTH
> > Jason
> > Atlanta, GA
> >
> > >-----Original Message-----
> > >Hello
> > >
> > >I was trying to make a formula to conditional format a
> > cell. I wanted the
> > >formula to be (if the cell is blank). I wanted to make
> > the cell have a red
> > >border if it was blank. I know how to make make the
> > border red if the
> > >condition is true, but im not sure how to write the
> > formula for this.
> > >
> > >Thanks for your help.
> > >.
> > >
> >