Prev: HELP!! Formula with different conditions
Next: why do print range erase in Excel when import data from access
From: HeatherJ on 17 Feb 2010 13:13
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

From: T. Valko on 17 Feb 2010 13:28
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 tab>Styles>Conditional Formatting>Manage rules>New rule>Use 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 Format>Conditional 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" <HeatherJ(a)discussions.microsoft.com> wrote in message
news:B9CD0E52-6DB3-4085-84D0-786677259248(a)microsoft.com...
>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
>


From: Luke M on 17 Feb 2010 13:30
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
>
From: HeatherJ on 17 Feb 2010 14:04
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
> >
From: HeatherJ on 17 Feb 2010 14:11
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 tab>Styles>Conditional Formatting>Manage rules>New rule>Use 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 Format>Conditional 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" <HeatherJ(a)discussions.microsoft.com> wrote in message
> news:B9CD0E52-6DB3-4085-84D0-786677259248(a)microsoft.com...
> >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
> >
>
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: HELP!! Formula with different conditions
Next: why do print range erase in Excel when import data from access