conditional formatting group of cells
 

Hello Excel users.

I have a column that is filled with either blanks, "Y", or "N" in each cell.
It is easy enough to format each of those cells to be grey/gray when a "Y"
is in the cell. My question is this: is there a way (besides using a macro)
to have the row that the "Y" is in to be grey as well as the cell containing
the "Y"?

In other words, is there a way to highlight the whole row--or a range of
cells on that row--that contains the "Y" by using conditional formatting
(there is other information in the adjacent columns that is not to be
changed) instead of using a macro after all the Y's and N's have been input?


dantee.

conditional formatting group of cells
 

One way:

Say the column is H:H. Then select your cells with, say, a cell in row 1
active, and use

CF1: Formula is =$H1="Y"
Format1: <pattern/<grey/gray

In article ,
dantee wrote:

Hello Excel users.

I have a column that is filled with either blanks, "Y", or "N" in each cell.
It is easy enough to format each of those cells to be grey/gray when a "Y"
is in the cell. My question is this: is there a way (besides using a macro)
to have the row that the "Y" is in to be grey as well as the cell containing
the "Y"?

In other words, is there a way to highlight the whole row--or a range of
cells on that row--that contains the "Y" by using conditional formatting
(there is other information in the adjacent columns that is not to be
changed) instead of using a macro after all the Y's and N's have been input?


dantee.

conditional formatting group of cells
 

Yes. In the conditional formatting use "Formula is", rather than "cell
value is". If your Y is in column D, and you have row 2 selected as the
active row, use "Formula is" =$D2="Y"
Note the absolute addressing for the column and relative addressing for the
row.
--
David Biddulph

"dantee" wrote in message
...
Hello Excel users.

I have a column that is filled with either blanks, "Y", or "N" in each
cell.
It is easy enough to format each of those cells to be grey/gray when a "Y"
is in the cell. My question is this: is there a way (besides using a
macro)
to have the row that the "Y" is in to be grey as well as the cell
containing
the "Y"?

In other words, is there a way to highlight the whole row--or a range of
cells on that row--that contains the "Y" by using conditional formatting
(there is other information in the adjacent columns that is not to be
changed) instead of using a macro after all the Y's and N's have been
input?


dantee.