Prev: HELP!! Formula with different conditions
Next: why do print range erase in Excel when import data from access
From: T. Valko on 17 Feb 2010 15:03
>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" <HeatherJ(a)discussions.microsoft.com> wrote in message
news:987D5094-70FC-46A6-BA1A-8710775AA1F2(a)microsoft.com...
> 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
>> >
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: HELP!! Formula with different conditions
Next: why do print range erase in Excel when import data from access