How do I usse conditional formatting to tell all the cells in a particular
column to change one color if there is something in a cell, and another if
it is blank?

The column in question is the "Date Closed" column and I want the blank
cells to stand out from the rest.
Thanks
Ross

Select the column (I used E).

And with E1 the active cell...

Format|conditional formatting
formula is: =E1=""
choose a nice format



Ross wrote:

How do I usse conditional formatting to tell all the cells in a particular
column to change one color if there is something in a cell, and another if
it is blank?

The column in question is the "Date Closed" column and I want the blank
cells to stand out from the rest.
Thanks
Ross

--

Dave Peterson

I tried that and it didn't work. Probably did it wrong. I selected the
column -- in my case J, with J1 active cell (how do I make it the active
cell? by clicking before I select the column?). then went to conditional
formatting, selecte formula from dropdown and pasted in your formula and
changed it to suit my column It now reads ="j1=" I set the format so the
cell background would become red, but when I clicked ok, no change occured.
Ross
"Dave Peterson" wrote in message
...
Select the column (I used E).

And with E1 the active cell...

Format|conditional formatting
formula is: =E1=""
choose a nice format



Ross wrote:

How do I usse conditional formatting to tell all the cells in a
particular
column to change one color if there is something in a cell, and another
if
it is blank?

The column in question is the "Date Closed" column and I want the blank
cells to stand out from the rest.
Thanks
Ross

--

Dave Peterson

Hi!

with J1 active cell (how do I make it the active cell? by clicking before I
select the column?)

When you select a range of cells, say, J1:J10, the first cell in the range
has no "shaded" color while the rest are "shaded" a blueish gray. The cell
that is not shaded (the first cell in the range) is the active cell. You
could also select the range from J10:J1 and J10 would be the active cell. As
a general rule it's best to select ranges from top to bottom or left to
right.

It now reads ="j1="

Change that to:

=J1=""

Biff

"Ross" wrote in message
...
I tried that and it didn't work. Probably did it wrong. I selected the
column -- in my case J, with J1 active cell (how do I make it the active
cell? by clicking before I select the column?). then went to conditional
formatting, selecte formula from dropdown and pasted in your formula and
changed it to suit my column It now reads ="j1=" I set the format so the
cell background would become red, but when I clicked ok, no change occured.
Ross
"Dave Peterson" wrote in message
...
Select the column (I used E).

And with E1 the active cell...

Format|conditional formatting
formula is: =E1=""
choose a nice format



Ross wrote:

How do I usse conditional formatting to tell all the cells in a
particular
column to change one color if there is something in a cell, and another
if
it is blank?

The column in question is the "Date Closed" column and I want the blank
cells to stand out from the rest.
Thanks
Ross

--

Dave Peterson

And just to add to Biff's response...

If you select the column J by clicking on the column header with Row 1 visible,
then J1 should be the activecell.

(Or select J1 and hit ctrl-spacebar)

Biff wrote:

Hi!

with J1 active cell (how do I make it the active cell? by clicking before I
select the column?)

When you select a range of cells, say, J1:J10, the first cell in the range
has no "shaded" color while the rest are "shaded" a blueish gray. The cell
that is not shaded (the first cell in the range) is the active cell. You
could also select the range from J10:J1 and J10 would be the active cell. As
a general rule it's best to select ranges from top to bottom or left to
right.

It now reads ="j1="

Change that to:

=J1=""

Biff

"Ross" wrote in message
...
I tried that and it didn't work. Probably did it wrong. I selected the
column -- in my case J, with J1 active cell (how do I make it the active
cell? by clicking before I select the column?). then went to conditional
formatting, selecte formula from dropdown and pasted in your formula and
changed it to suit my column It now reads ="j1=" I set the format so the
cell background would become red, but when I clicked ok, no change occured.
Ross
"Dave Peterson" wrote in message
...
Select the column (I used E).

And with E1 the active cell...

Format|conditional formatting
formula is: =E1=""
choose a nice format



Ross wrote:

How do I usse conditional formatting to tell all the cells in a
particular
column to change one color if there is something in a cell, and another
if
it is blank?

The column in question is the "Date Closed" column and I want the blank
cells to stand out from the rest.
Thanks
Ross

--

Dave Peterson



--

Dave Peterson