conditional format on column based on cell value
 

I want to highlight an entire column based on the value of one cell in the
column.

The column is B. The cell is B2. If the value of B2 is Y, I want the
entire column B highlighted yellow.

Here is what I have tried based on other's posts to no avail:
I select column B
Go to Conditional Formatting
Highlight Cell Rules
More Rules
Use Formula...
type in =$B2="y"
click Format
select yellow fill
hit Ok
hit Ok
Only the first cell in the column (B1) is highlighted.

I have also tried the above beginning by selecting cells in column B instead
of selecting the entire column with the same result.

conditional format on column based on cell value
 

Make it $B$2

"kixy1" wrote:

I want to highlight an entire column based on the value of one cell in the
column.

The column is B. The cell is B2. If the value of B2 is Y, I want the
entire column B highlighted yellow.

Here is what I have tried based on other's posts to no avail:
I select column B
Go to Conditional Formatting
Highlight Cell Rules
More Rules
Use Formula...
type in =$B2="y"
click Format
select yellow fill
hit Ok
hit Ok
Only the first cell in the column (B1) is highlighted.

I have also tried the above beginning by selecting cells in column B instead
of selecting the entire column with the same result.

conditional format on column based on cell value
 

RESOLVED

UGH! Can't believe I missed that. Just upgraded to 2007 and getting a
little loopy and frustrated trying to learn all the new and "easier" ways to
do things...

Thanks for you help!

"akphidelt" wrote:

Make it $B$2

"kixy1" wrote:

I want to highlight an entire column based on the value of one cell in the
column.

The column is B. The cell is B2. If the value of B2 is Y, I want the
entire column B highlighted yellow.

Here is what I have tried based on other's posts to no avail:
I select column B
Go to Conditional Formatting
Highlight Cell Rules
More Rules
Use Formula...
type in =$B2="y"
click Format
select yellow fill
hit Ok
hit Ok
Only the first cell in the column (B1) is highlighted.

I have also tried the above beginning by selecting cells in column B instead
of selecting the entire column with the same result.