Conditional Formatting

[Ant]

I have a workbook where I would like to apply conditional formatting to an
entire row, depending on the condition in the first column. I know how to
apply the formatting to the cell in the first column but not the rest of the
cells on that row. E.g. something like if the formatting of A1 = ?? then
also apply the same formatting to A2, A3 etc. If this can not be done using
conditional formatting then is there another way?



Thanks for any help.

[Duke Carey]

Select the entire range of cells in the row you want formatted and go into
Conditional Formatting

Now, instead of using "Cell value is" use "Formula is" and use a formula
along the lines of:

=A$1=your value



"Ant" wrote:

> I have a workbook where I would like to apply conditional formatting to an
> entire row, depending on the condition in the first column. I know how to
> apply the formatting to the cell in the first column but not the rest of the
> cells on that row. E.g. something like if the formatting of A1 = ?? then
> also apply the same formatting to A2, A3 etc. If this can not be done using
> conditional formatting then is there another way?
>
>
>
> Thanks for any help.
>
>
>

[Duke Carey]

sorry, make that

=$A$1= your value

"Ant" wrote:

> I have a workbook where I would like to apply conditional formatting to an
> entire row, depending on the condition in the first column. I know how to
> apply the formatting to the cell in the first column but not the rest of the
> cells on that row. E.g. something like if the formatting of A1 = ?? then
> also apply the same formatting to A2, A3 etc. If this can not be done using
> conditional formatting then is there another way?
>
>
>
> Thanks for any help.
>
>
>

[Ant]

Thanks for that. it works spot on!

Cheears


"Duke Carey" <[email protected]> wrote in message
news:[email protected]...
> sorry, make that
>
> =$A$1= your value
>
> "Ant" wrote:
>
>> I have a workbook where I would like to apply conditional formatting to
>> an
>> entire row, depending on the condition in the first column. I know how
>> to
>> apply the formatting to the cell in the first column but not the rest of
>> the
>> cells on that row. E.g. something like if the formatting of A1 = ??
>> then
>> also apply the same formatting to A2, A3 etc. If this can not be done
>> using
>> conditional formatting then is there another way?
>>
>>
>>
>> Thanks for any help.
>>
>>
>>

[Gord Dibben]

Ant

General idea since you don't provide quite enough detail.

Select rows 1:3 then Format>CF>Formula is: =$A1=10

Note the $ sign to anchor the column.

Pick a pattern from the Format button and OK your way out.

If A1 = 10 then that entire row will be formatted.

Same for A2 and A3

If not what you need, post back with some specifics.


Gord Dibben Excel MVP



On Thu, 08 Dec 2005 19:07:00 GMT, "Ant" <[email protected]> wrote:

>I have a workbook where I would like to apply conditional formatting to an
>entire row, depending on the condition in the first column. I know how to
>apply the formatting to the cell in the first column but not the rest of the
>cells on that row. E.g. something like if the formatting of A1 = ?? then
>also apply the same formatting to A2, A3 etc. If this can not be done using
>conditional formatting then is there another way?
>
>
>
>Thanks for any help.
>