Conditional Formatting

T

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.
 
D

daddylonglegs

Select whole range then apply this formula within conditional
formatting

formula is

=$A5>1000
 
P

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
 
T

Terry Bennett

Thanks guys - works well!

Peo Sjoblom said:
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
Click to expand...
 
Top