Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting for entire row
I know how to use conditional formatting for a cell, but is there a way to do
conditional formatting for an entire row? Example: if cell A18 contains the text, "total" then row 18 has a top and bottom border. Thanks, Heather |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting for entire row
Do you really mean the *entire* row or just a portion of the row?
Let's assume you want to format A18:J18 Select the *entire* range A18:J18 starting from cell A18. Cell A18 will be the active cell. The active cell is the one cell in the selected range that is not shaded. The formula will be relative to the active cell. If you really do mean the *entire* row then left click the row number header. In Excel 2007: Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =$A18="total" Click the Format button Select the Borders tab Select the border style OK out In Excel versions 2003 and earlier Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =$A18="total" Click the Format button Select the Borders tab Select the border style OK out -- Biff Microsoft Excel MVP "HeatherJ" wrote in message ... I know how to use conditional formatting for a cell, but is there a way to do conditional formatting for an entire row? Example: if cell A18 contains the text, "total" then row 18 has a top and bottom border. Thanks, Heather |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting for entire row
Select entire row(s). Conditional format - formula is:
=$A18="total" (note the placement of the absolute reference) Format as desired. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "HeatherJ" wrote: I know how to use conditional formatting for a cell, but is there a way to do conditional formatting for an entire row? Example: if cell A18 contains the text, "total" then row 18 has a top and bottom border. Thanks, Heather |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting for entire row
Can I select an entire sheet and apply this? to say something like if
"total" appears in a cell in column A then apply a format to that row? Thanks again! "Luke M" wrote: Select entire row(s). Conditional format - formula is: =$A18="total" (note the placement of the absolute reference) Format as desired. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "HeatherJ" wrote: I know how to use conditional formatting for a cell, but is there a way to do conditional formatting for an entire row? Example: if cell A18 contains the text, "total" then row 18 has a top and bottom border. Thanks, Heather |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting for entire row
You're right, I really don't need the entire row. Also, my question wasn't
clear. I have a large worksheet with total rows throughout-- Can I select the entire sheet and apply a conditional format to those certain rows? to say something like if "total" appears in a cell in column A then apply a format to that row (or perhaps A18:J18 like you said)? Thanks again! "T. Valko" wrote: Do you really mean the *entire* row or just a portion of the row? Let's assume you want to format A18:J18 Select the *entire* range A18:J18 starting from cell A18. Cell A18 will be the active cell. The active cell is the one cell in the selected range that is not shaded. The formula will be relative to the active cell. If you really do mean the *entire* row then left click the row number header. In Excel 2007: Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =$A18="total" Click the Format button Select the Borders tab Select the border style OK out In Excel versions 2003 and earlier Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =$A18="total" Click the Format button Select the Borders tab Select the border style OK out -- Biff Microsoft Excel MVP "HeatherJ" wrote in message ... I know how to use conditional formatting for a cell, but is there a way to do conditional formatting for an entire row? Example: if cell A18 contains the text, "total" then row 18 has a top and bottom border. Thanks, Heather . |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting for entire row
Can I select the entire sheet and apply a conditional format
Ok, just like the entire row, the *entire* sheet is probably overkill! Let's say you have data in the range A18: J500. Just select that specific range the way I described in my other post. Or, an easier way to select large ranges is to type the range address in the name box. That little "box" immediately above the column A header that tells you what cell is selected. Type in the range such as A18:J500 then hit Enter. The range will be selected and A18 will be the active cell. Then set the formatting just as I explained in my other post. The formula will be the same: =$A18="total" -- Biff Microsoft Excel MVP "HeatherJ" wrote in message ... You're right, I really don't need the entire row. Also, my question wasn't clear. I have a large worksheet with total rows throughout-- Can I select the entire sheet and apply a conditional format to those certain rows? to say something like if "total" appears in a cell in column A then apply a format to that row (or perhaps A18:J18 like you said)? Thanks again! "T. Valko" wrote: Do you really mean the *entire* row or just a portion of the row? Let's assume you want to format A18:J18 Select the *entire* range A18:J18 starting from cell A18. Cell A18 will be the active cell. The active cell is the one cell in the selected range that is not shaded. The formula will be relative to the active cell. If you really do mean the *entire* row then left click the row number header. In Excel 2007: Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =$A18="total" Click the Format button Select the Borders tab Select the border style OK out In Excel versions 2003 and earlier Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =$A18="total" Click the Format button Select the Borders tab Select the border style OK out -- Biff Microsoft Excel MVP "HeatherJ" wrote in message ... I know how to use conditional formatting for a cell, but is there a way to do conditional formatting for an entire row? Example: if cell A18 contains the text, "total" then row 18 has a top and bottom border. Thanks, Heather . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting the entire row | Excel Discussion (Misc queries) | |||
Conditional formatting Max to a entire row A1:D1 with E1 being Ma | Excel Worksheet Functions | |||
conditional formatting for entire row | Excel Discussion (Misc queries) | |||
Conditional Formatting Entire Row | Excel Discussion (Misc queries) | |||
2007 Conditional Formatting entire row | Excel Discussion (Misc queries) |