| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format based on data from another column | Excel Discussion (Misc queries) | |||
| Conditional Format based on other cell | Excel Discussion (Misc queries) | |||
| Conditional Format based on other cell | Excel Discussion (Misc queries) | |||
| Conditional Format a column based on another | Excel Discussion (Misc queries) | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
Linear Mode
