Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |