Conditional Formatting
 

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.

Conditional Formatting
 

Select whole range then apply this formula within conditional
formatting

formula is

=$A51000


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=521551

Conditional Formatting
 

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 formatconditional formatting, select formula is and in the formula
box put

=$A$51000

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" wrote in message
...
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.

Conditional Formatting
 

Thanks guys - works well!

"Peo Sjoblom" wrote in message
...
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 formatconditional formatting, select formula is and in
the formula box put

=$A$51000

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" wrote in message
...
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.