Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy conditional formatting with 'unique' cell references
Can I copy conditional formatting from one cell to another when the cells need to have different cell references in the formulas? For example: I need to format the entire row when a Y is put into the end cell. So the conditional formatting formula is =$H$2="y" and the next cell needs to be =$H$3="y" then =$H$4="y" and so on, but I cannot find a way to set the whole column up like that without doing every row manually. If I use the format painter then the whole of the "H" column uses the same formula =$E$2="y" and then all the rows are formatted when you put a into the first cell instead of being treated seperatly. Any ideas? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy conditional formatting with 'unique' cell references
I suggest you look up in help the difference between relative & absolute
addressing. Try =$H2="y" instead of =$H$2="y" -- David Biddulph "Sam" wrote in message news:op.thmyx1s4b2r405@pc-sam... Can I copy conditional formatting from one cell to another when the cells need to have different cell references in the formulas? For example: I need to format the entire row when a Y is put into the end cell. So the conditional formatting formula is =$H$2="y" and the next cell needs to be =$H$3="y" then =$H$4="y" and so on, but I cannot find a way to set the whole column up like that without doing every row manually. If I use the format painter then the whole of the "H" column uses the same formula =$E$2="y" and then all the rows are formatted when you put a into the first cell instead of being treated seperatly. Any ideas? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - copy absolute cell references (within the range) as relati | Excel Discussion (Misc queries) | |||
Conditional Formatting if cell content is a formula | Excel Worksheet Functions | |||
conditional formatting on a cell range | Excel Discussion (Misc queries) | |||
Applying conditional formatting to cell based on another cell's in | Excel Discussion (Misc queries) | |||
Conditional Formatting For A Cell Other Than The One With The Form | Excel Worksheet Functions |