conditional format on column based on cell value

's Computer Specifications

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.

's Computer Specifications

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.
>
>

's Computer Specifications

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.
> >
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional format based on a different column	ArcticWolf	Microsoft Excel Worksheet Functions	2	23rd Jan 2009 10:15 AM
Conditional format row based on 1 column.	FStuttgen	Microsoft Excel Misc	3	4th Nov 2008 07:36 PM
Conditional Format a column based on another	=?Utf-8?B?S2FybQ==?=	Microsoft Excel Misc	6	30th Oct 2006 11:39 AM
conditional cell format based on cell in same row, previous column	=?Utf-8?B?dGFtaWx1Y2hp?=	Microsoft Excel Worksheet Functions	7	3rd May 2006 04:11 PM
conditional format based on value anywhere in a column	lone pilgrim	Microsoft Excel Discussion	2	28th Jul 2004 07:13 PM