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]

Thanks guys - works well!

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