conditional format on column based on cell value

K

kixy1

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

kixy1

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional format a column based on value in a different column 3
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Excel conditional formatting with Weeknum 4
Conditional Formatting Help 1
Conditional Format a dynamic list in Excel 2007 1
Change formulas in a column based on a selection. 3
Copy conditional formatting across column in the same row 2
Colors according to the month 3

Top