Conditional Formatting

[Terry Bennett]

It is very easy to format a cell dependant on the value of that cell itself.

How do I apply the same conditional formatting to a row of cells based on
the value of one cell in that row? ie; if A5 > 1,000 make A5 bold, but also
B5, C5, D5, etc.

Sorry if this is very obvious but I can't seem to work it out and can't see
any recent posts on the subject.

[daddylonglegs]

Select whole range then apply this formula within conditional formatting

formula is

=$A5>1000

[Peo Sjoblom]

Select all cells in question starting with A5 (meaning A5 will be the active
cell and the cell reference you will see in the name box above column A),
then do format>conditional formatting, select formula is and in the formula
box put

=$A$5>1000

click the format button, font and select bold, click OK twice



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Terry Bennett" <[email protected]> wrote in message
news:[email protected]...
> It is very easy to format a cell dependant on the value of that cell
> itself.
>
> How do I apply the same conditional formatting to a row of cells based on
> the value of one cell in that row? ie; if A5 > 1,000 make A5 bold, but
> also B5, C5, D5, etc.
>
> Sorry if this is very obvious but I can't seem to work it out and can't
> see any recent posts on the subject.
>

[Terry Bennett]

Thanks guys - works well!

"Peo Sjoblom" <peo.sjoblom@^^nwexcelsolutions.com> wrote in message
news:%[email protected]...
> Select all cells in question starting with A5 (meaning A5 will be the
> active cell and the cell reference you will see in the name box above
> column A), then do format>conditional formatting, select formula is and in
> the formula box put
>
> =$A$5>1000
>
> click the format button, font and select bold, click OK twice
>
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Northwest Excel Solutions
>
> www.nwexcelsolutions.com
>
> (remove ^^ from email address)
>
> Portland, Oregon
>
>
>
>
> "Terry Bennett" <[email protected]> wrote in message
> news:[email protected]...
>> It is very easy to format a cell dependant on the value of that cell
>> itself.
>>
>> How do I apply the same conditional formatting to a row of cells based on
>> the value of one cell in that row? ie; if A5 > 1,000 make A5 bold, but
>> also B5, C5, D5, etc.
>>
>> Sorry if this is very obvious but I can't seem to work it out and can't
>> see any recent posts on the subject.
>>
>